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 “upwind” 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.

253 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
upwind1225582(None) 
unwind102610541unwind
upbind11246311upbind
upwinds13224221upwinds
enwind10298082enwind
inwind10268412inwind
outwind1139152outwind
poind84217912_poind
rewind104715882rewind
unbind93011432unbind
unkind113310572unkind
unwinds11286732unwinds
upbinds12234812upbinds
upend85011042up_end
upgird10103932upgird
upland938862upland
uplink12388712uplink
upping114013702upping
upsend9356882upsend
upswing1335592upswing
upward12147162upward
wind85533852__wind
aphid115515393aphi_d
aping87327233ap_ing
append1138273append
awing96827323_awing
behind1238063behind
bind76234513__bind
blind86319323_blind
bowing124723063bowing
cawing124322613cawing
cowbind1536613cowbind
cowing124526323cowing
cupid103212783cup_i_d
cupping144312383cupping
dawing114819823dawing
dewing114115703dewing
dowing114221513dowing
duping104113633dup_ing
dupping133711043dupping
dwine95616143_dwine
dwined114610213_dwined
enwinds11255553enwinds
find87532603__find
grind75917563_grind
gwine95513663_gwine
hawing134322353hawing
hewing134514243hewing
hind85529753__hind
inwinds11216273inwinds
jawing174414963jawing
jewing174411423jewing
jowing174216043jowing
kind96128563__kind
lapwing13308263lapwing
lawine93316463lawine
lawing104625283lawing
lowing104623273lowing
lupin75215843lup_in_
lupine84013533lup_ine
lupins84514463lup_ins
mawing124020803mawing
mewing123914203mewing
mind75434383__mind
mowing124119093mowing
opine77422463op_ine
opined95113853op_ined
oping86322413op_ing
opsin7613473opsin_
opsins8411713opsins
opting94514403opting
outfind1139563outfind
outwinds1235363outwinds
owing96222723_owing
paid75737483_pai_d
pain65647243_pain_
pained95622853_pained
pains75138283_pains
paint75443693_paint
pawing124519553pawing
pein65834943_pein_
peined94918843_peined
peins76128063_peins
pend75934533_p_end
pied75035363_p_ied
piing85218833_piing
pin57066723_p_in_
pina65842633_p_ina
pine67755713_p_ine
pined85935323_p_ined
ping75943593_p_ing
pink107039383_p_ink
pins65558453_p_ins
pint66963173_p_int
piny911838353_p_iny
plied85118593_plied
plink115219123_plink
poinds93511143_poinds
point75338733_point
pond75530493_p_ond
pound84417863_pound
pried84426863_pried
prink114719673_prink
print74837463_print
puking133913063puking
puling93621403puling
pupping114412503pupping
purin75527593purin_
purine85321893purine
purins83722653purins
pyin96823233_pyin_
pyins105815863_pyins
rawin85521473rawin_
rawins95617623rawins
rebind94416933rebind
refind104717073refind
remind94819793remind
rewin85623963rewin_
rewinds114810483rewinds
rewins95020823rewins
rind56535603__rind
rowing103623303rowing
sawing104323813sawing
sewing103819623sewing
sowing104222913sowing
spend85619333sp_end
spewing133110453spewing
sphinx1866203sphinx
spied85427713sp_ied
spin66231303sp_in_
spine76534423sp_ine
spined95423943sp_ined
spins75327983sp_ins
spiny104921303sp_iny
spline86020533spline
splined105013113splined
splint85223283splint
spring94526013spring
sprint84526793sprint
spuing94313363spuing
spying123913253spying
supine84216693sup_ine
supping123814533supping
swine85625303_swine
swing96124843_swing
swink125116353_swink
tawing104521553tawing
teind6213613_teind
tewing103914823tewing
towing103823193towing
tupping123411663tupping
twin76023083_twin_
twine85822363_twine
twined104413123_twined
twins85118983_twins
twiny116012813_twiny
umping114815333umping
unbend9269773unbend
unbid83214643unbi_d
unbinds10267353unbinds
uncini8310153uncini
undid72415363undi_d
undine7817263undine
unfond10149113unfond
ungird887973ungird
unhand10410383unhand
unkend11309223unkend
unkink9308713unkink
unlined82515803unlined
unlink104011013unlink
unmined102612953unmined
unpaid939473unpai_d
unpin72613243unpin_
unpins82312383unpins
untied73720813untied
untwine1038623untwine
untwined1237063untwined
unwed94114873unw_ed
unwinder1235613unwinder
unwise9510803unwise
unwish1239093unwish
unwit84417523unwi_t
unwits9389893unwits
unwon84512343unwon_
unwound11126613unwound
upbound12134813upbound
upbuild1243003upbuild
updive1234903updive
updived1434093updived
updried11226473updried
upends9438763up_ends
upfield1343033upfield
upfling1337093upfling
upfold12124953upfold
upgirds11103073upgirds
upgirt9117263upgirt
upgoing1135353upgoing
upheld12115563upheld
uphill11106173uphill
uphold12126903uphold
uplands1036943uplands
uplift114610653uplift
uplinked15254203uplinked
uplinks13345613uplinks
uplit76020803upli_t
upload9257783upload
upon65817583up_on_
upped103715163up_ped
uppile10178503uppile
uppiled12216593uppiled
uppings12257123uppings
uppish1336633uppish
uppity1335103uppity
uprise82313693uprise
upsends10265293upsends
upsent83314063upsent
upside9289803upside
upsize17267303upsize
upsized19246253upsized
upstand1045343upstand
upswings1433003upswings
upswung1341783upswung
uptick1436763uptick
uptilt8410803uptilt
uptime1067673uptime
uptrend1044293uptrend
upwaft1444943upwaft
upwards13135963upwards
upwell11285803upwell
urging83413123urging
urine55026603u_rine
urping93914053urping
ursid6311483ursi_d
ursine64114123ursine
using66317963u_sing
vowing133715273vowing
wand85833883__wand
wend85330453__wend
wild85126513__wild
win66456293__win_
winds95425603__winds
windy126118103__windy
wine74953423__wine
wined94434183__wined
wing86339223__wing
wink116435023__wink
wino75933613__wino
wins75949173__wins
winy107034323__winy
wowing133915393wowing
wynd116114463__wynd
yawing134215613yawing
yowing133715543yowing

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 Filter1786911127160.373479064.3
2DLD Change Limit1127162535.58020200.0
3Display Results2532530.0932720.4
 (SQL Overall)1786912536.04629555.2
 
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.