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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

167 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
enwinds1125555(None) 
enwind10298081enwind_
inwinds11216271inwinds
unwinds11286731unwinds
encinas938722encinas
endings92910442endings
engilds974862engilds
engines81114462engines
engirds995052engirds
entwines1148752entwines
inwind10268412inwind_
rewinds114810482rewinds
unbinds10267352unbinds
unwind102610542unwind_
upwinds13224222upwinds
winds95425602__winds
anginas8310953anginas
anoints7311063anoints
antings85015583antings
awnings11406713awnings
behinds1335283behinds
benzines1938213benzines
benzins1838693benzin_s
binds86627473__binds
blinds95111613_blinds
bowings133612003bowings
cowbinds1634453cowbinds
dentines93418403dentines
dentins83419223dentin_s
dwines105013103_dwines
eanlings9128473eanlings
earings84517713earings
eatings84616443eatings
echinus1236203echinus
edgings10256243edgings
elains64919853elain_s
elands74914773e_lands
elfins94810943elfin_s
elints65816423e_lints
eloins65419383eloin_s
emends95711433e_mends
enamines101112133enamines
encina8310443encin_a
encinal949243encinal
ending83220253endin_g
endites83717063endites
endives113710693endives
endrins8312163endrin_s
ends56528523e___nds
enfolds11136253enfolds
engild8107613engild_
engine71114863engin_e
engined9119893engined
enginous946493enginous
engird8126973engird_
enjoins1457333enjoin_s
enkindle1363163enkindle
enkindles1463133enkindles
enlists749393enlists
enneads834733enneads
ensigns836353ensigns
ensiles72714833ensiles
entices91616333entices
entires71517783entires
entwine1039143entwin_e
entwined1235843entwined
entwists1156143entwists
envied1038833envied_
enviers1036993enviers
envies9314053envi_es
envious1037223envious
enviros1034913enviros
enwinding1444933enwinding
enwombs1443633enwombs
enwound11134813enwound_
enwraps1284833enwraps
eosines73718293eosines
eosins64419163eosin_s
equids16439143equi_ds
equines161811593equines
ermines9416673ermines
errands847603errands
exines135715803e_xines
expands17195733expands
expends17217083expends
exscinds1842533exscinds
extends15227113extends
eyewinks1841753eyewinks
fencings14225663fencings
fenlands1245183fenlands
finds95424823__finds
gnawings13263773gnawings
grinds84511843_grinds
headwinds1743153headwinds
hinds96721473__hinds
inlands838783inlands
innings8329443innings
intends8239963intends
intines7921113intines
intwines1138043intwines
inwards1138343inwards
kennings13315273kennings
kinds106221823__kinds
knowings16234043knowings
lawines103313563lawines
lawings113611473lawings
lowings113710073lowings
mendings12338303mendings
minds85427123__minds
mowings13328483mowings
naiads739013_naiads
newies91014073newi_es
nines55937343_n_ines
onwards1137173onwards
outwinds1235363outwinds
overwinds1645573overwinds
pennines103112043pennines
poinds93511143_poinds
rawins95617623rawin_s
rebinds104511873rebinds
redwings13305733redwings
refinds114512123refinds
regrinds1035533regrinds
reminds104614793reminds
renins64526453ren_in_s
rennins74013413rennin_s
rescinds1136333rescinds
rewind104715883rewind_
rewins95020823rewin_s
rinds64826143__rinds
rowings113710363rowings
sewings11369173sewings
swings104714453_swings
swinks134610653_swinks
teinds738263_teinds
tenpins9410073tenpin_s
twines94717273_twines
twins85118983_twin_s
unbends10236993unbends
unbind93011433unbind_
uncinus937403uncinus
undines8716083undines
ungirds9105303ungirds
unhands1137773unhands
unkind113310573unkind_
unkinks10265413unkinks
unlinks11307403unlinks
unpins82312383unpin_s
untwines1137603untwines
unwinder1235613unwinder
unwinders1343943unwinders
unwits9389893unwi_ts
upbinds12234813upbinds
upwind12255823upwind_
venines103516613ven_ines
venins93816703ven_in_s
wands96425483__wands
wends95822813__wends
wilds94818203__wilds
wind85533853__wind_
windy126118103__windy
wines85546863__wines
wings95727243__wings
winks125325433__winks
winos84625043__winos
wins75949173__win_s
wynds126310373__wynds

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.390458182.1
2DLD Change Limit1340271676.47020715.1
3Display Results1671670.0602783.3
 (SQL Overall)1786911676.92025822.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.