Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “guipure” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

66 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
guipure104353(None) 
guipures1143731guipures
purpure1195992purpure
unpure82911532_unpure
culture939393culture
cupule103410723cu_pule
cutpurse1243133cutpurse
epicure1136823epicure
failure1035753failure
figure10258833_figure
fixure16256543_fixure
future939563fu_ture
geniture946453geniture
gesture839243gesture
gigue71210673g_igu_e
gipper114215303g_ipper
goitre7349003goi_tre
gravure1134953gravure
gripe84622963grip__e
griper94114613griper_
gripers104011463gripers
gripier103210323gripier
grippe115310323grip_pe
gripper124410713gripper
gripple12416613gripple
guayule1142823guayule
guide75019893gui__de
guider84313523guider_
guiders94111113guiders
guilder945913guilder
guile64521133gui__le
guimpe1134723gui_mpe
guiro63712093gui__ro
guisard954203guisard
guise64717713gui__se
guitar7117443guitar_
guitars8116863guitars
gulper93410213gulper_
gulpers10299013gulpers
gulpier1046953gulpier
gunfire1134743gunfire
gyplure13122013gyplure
humiture1344123humiture
impure1038383_impure
inure54119053__inure
leisure736693leisure
ligure7279473_ligure
multure939183multure
nurture736643nurture
pure65543333___pure
purpura1144793purpura
purpures1276143purpures
quipper2095823quipper
quipu164811643quipu__
quipus17458003quipu_s
quire144917133qui__re
rupture966163rupture
seisure738193seisure
seizure1634683seizure
soilure736233soilure
stipule936723stipule
suspire937803suspire
suture6313203su_ture
umpire1047893_umpire
unsure62815413_unsure
vulture1036763vulture

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.403443402.0
2DLD Change Limit134027665.95322514.2
3Display Results66660.0332000.0
 (SQL Overall)178691666.38927968.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.