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 “wynd” with Change Limit: [1] [2] [3]

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
to automatically increase the Change Limit after seconds.

100 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
wynd11611446(None) 
rynd86414101rynd
wand85833871wand
wend85330451wend
wind85533851wind
wyn95921441wyn_
wynds126310371wynds
wynn105811291wynn
wyns105717031wyns
and47244162_and
band76740902band
bend76435262bend
bind76234512bind
bond75334362bond
bund75530662bund
dyad96415452dyad
dyed96720762dyed
dyne85320932dyne
end46834352_end
eyed86623232eyed
eyne76322462eyne
fend84832972fend
find87532602find
fond86330952fond
fund85624982fund
hand86833702hand
hind85529752hind
kind96128552kind
land56337302land
lend56233672lend
lynx1437422lynx
mend75334022mend
mind75434372mind
myna95815292myna
pend75934532pend
pond75530492pond
rand55839562rand
rend56136572rend
rind56535602rind
rynds9569972rynds
sand55338462sand
send55237292send
syn67024122syn_
sync95415102sync
syne75725762syne
synod9610282synod
tend56433772tend
tyne76325052tyne
tyned95915012tyned
vend86626422vend
wad77053892w_ad
wan66761932wan_
wands96425482wands
wane76344712wane
waned95831782waned
wank115632502wank
wans76452262wans
want76156162want
wany106432352wany
ward86542252ward
wed75843622w_ed
weed85637512weed
weld84727732weld
wen66249602wen_
wends95822812wends
wens76337932wens
went76051872went
whid115418872whid
wild85126512wild
win66456292win_
winds95425602winds
windy126118102windy
wine74953422wine
wined94434182wined
wing86339222wing
wink116435022wink
wino75933612wino
wins75949172wins
winy107034322winy
woad85523942woad
wold85429072wold
won66252062won_
wonk116125302wonk
wons74942042wons
wont75842502wont
wood85329382wood
word89832002word
wound94414212wound
wud76227152w_ud
wych154011882wych
wye96331972wy_e
wyes105727502wyes
wyle105519382wyle
wyled124611842wyled
wynns11517472wynns
wyte106018642wyte
wyted12529472wyted
yid76640822_yid
yod77545502_yod
yond86122312yond

Search took 3 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 Filter178691298720.1561145455.1
2DLD Change Limit298721001.76616915.1
3Display Results1001000.0462173.9
 (SQL Overall)1786911001.96890798.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.