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

271 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
window134736(None) 
indow95011661_indow
widow1278941wi_dow
windows1447741windows
windowy1744641windowy
windrow1445851windrow
winnow1234591winnow
endow94510982_endow
indol63714872_indol
indows104210792_indows
minnow1135582minnow
widows1376562wi_dows
willow12369692willow
wind85533862wind__
winded114918212winded
winder104025262winder
windle104617952windle
windowed1635572windowed
windrows1546162windrows
winds95425612wind_s
windup1235382windup
windy126118112wind_y
wingbow1643772wingbow
winnows1334532winnows
wino75933622win_o_
winos84625042win_os
wisdom1235982wisdom
bandog1038723bandog
billow114111223billow
bind76234523bind__
binder94422873binder
bindi85617023bind_i
bindis94614583bindis
bindle94516263bindle
binds86627483bind_s
bingo86020093bingo_
bingos95514793bingos
candor94516423candor
cinder94119123cinder
cineol8108203cineol
condo85322593condo_
condom114215363condom
condor94616973condor
condos94322333condos
dido66528213di_do_
didos76820823di_dos
dildo71911783dildo_
dildoe8198673dildoe
dildos8179303dildos
dindle84417223dindle
dingo74720793dingo_
dino56036763din_o_
dinos65428063din_os
disendow1343813disendow
dow76749973___dow
dwindle12415883dwindle
eidos65817763ei_dos
endows104610423_endows
enow77819873_en_ow
fandom122110893fandom
fido87726413fi_do_
fidos95819063fi_dos
find87532613find__
finder104020233finder
finds95424833find_s
fino76034703fin_o_
finos86226953fin_os
ginzo1539613ginzo_
gundog935793gundog
hind85529763hind__
hinder104120063hinder
hinds96721483hind_s
idol56818643_i_dol
incog838253_incog
index13310983_index
indie63721473_indie
indole74516053_indole
indols74714203_indols
indoor738403_indoor
indowed1237443_indowed
indri6310793_indri
indue63516673_indue
inflow1235293_inflow
info75617353_info_
infos84311673_infos
ingot61221063_ingot
inion54620183_inion
inro45920793_inro_
into45026153_into_
intown936153_intown
jingo134615213jingo_
kendo105113233kendo_
kendos114510663kendos
kiddo11398963kiddo_
kiddos12416873kiddos
kind96128573kind__
kinder113716853kinder
kindle114414243kindle
kindly14358853kindly
kinds106221833kind_s
kingdom1543543kingdom
kino86233633kin_o_
kinos96626153kin_os
know116115853_kn_ow
lido56028173li_do_
lidos65219893li_dos
linden7411453linden
lindy96918323lind_y
lingo66022113lingo_
lino46343383lin_o_
linos55631503lin_os
lintol6369473lintol
meadow1237403meadow
miaow1058353mi_aow
mildew12319043mildew
mind75434393mind__
minded103817833minded
minder94822503minder
minds85427133mind_s
minion83416243minion
minnows1234913minnows
minor74920063min_or
misdo85413193misdo_
mondo85721233mondo_
mondos95217333mondos
ninon55517383nin_on
now65950193__n_ow
pillow113110573pillow
pinder94523463pinder
pingo87122713pingo_
pingos95317673pingos
pinion83815893pinion
pinko115618253pinko_
pinkos125313873pinkos
pinon76024533pin_on
pinot78737293pin_ot
pinto75625753pinto_
pintos86021293pintos
pinyon11459763pinyon
qindar16317173qindar
rainbow1243353rainbow
random92513553random
reendow11285063reendow
rind56535613rind__
rinded84418983rinded
rinds64826153rind_s
rindy95717403rind_y
rondo65218373rondo_
rondos74616733rondos
rundown1165443rundown
shadow1337253shadow
sinew84718923sin_ew
snow76324793_sn_ow
sunbow1145823sunbow
sundew10369693sundew
sundog837613sundog
sundown1186313sundown
swindle11389183swindle
tendon7312033tendon
thindown1543373thindown
tinder73821803tinder
tinpot8312513tinpot
tondo69718683tondo_
tondos75115923tondos
undo55620163_undo_
vendor10359803vendor
vino76128443vin_o_
vinos84723073vin_os
wallow123913513wallow
wand85833883wand__
wander104423713wander
wandle105316663wandle
wands96425483wand_s
wanion93213063wanion
wanton94413813wanton
weirdo10405883weirdo_
weirdos11355123weirdos
weldor10317653weldor
wend85330453wend__
wended113616153wended
wends95822813wend_s
whitlow1642863whitlow
widder112913973widder
widdie113410733widdie
widdle113814843widdle
widdy136112193wi_ddy
wide85235423wi_d_e
widen94717983wi_den
wider94826363wi_der
wides94832833wi_des
widowed1534843wi_dowed
widower1435343wi_dower
width12310973wi_dth
wifedom1643553wifedom
wigeon1037223wigeon
wilco1039443wilco_
wild85126523wild__
wilded113714503wilded
wilder103616473wilder
wildfowl1842243wildfowl
wildly13328123wildly
wilds94818213wild_s
willows13299753willows
willowy16276353willowy
win66456303win___
wince105220883win_ce
winced124415343winced
wincer115018193wincer
winces114819113winces
wincey144110383wincey
winch135016663win_ch
windage1237933windage
windbag1444123windbag
windblown1851793windblown
winders113721263winders
windflaw1842293windflaw
windier113412163windier
windigo12415953windigo
windigos13484903windigos
windily1437943windily
winding123517913winding
windled123713483windled
windles113518493windles
windowing1744813windowing
windrowed1743723windrowed
windrower1644233windrower
windsock1843183windsock
windthrow1951423windthrow
windups1334783windups
windway1745153windway
wine74953433win__e
wined94434183win_ed
winery125014283winery
wines85546863win_es
winesop1264233winesop
winey115325433win_ey
wing86339233win__g
wingbows1743983wingbows
winged114620833winged
winger104125443winger
wings95727243win_gs
wingy126521033win_gy
winier94522453winier
wining103625053wining
winish124212273winish
wink116435033win__k
winked144018603winked
winker134220293winker
winkle133812833winkle
winks125325433win_ks
winned104017013winned
winner94219933winner
winnock1643893winnock
winnowed1543473winnowed
winnower1444253winnower
winoes94317013winoes
wins75949183win__s
winsome1237463winsome
winter94222803winter
wintle94014603wintle
wintry12498923wintry
winy107034333win__y
winze175014853win_ze
winzes184313053winzes
wisdoms1335453wisdoms
wittol935923wittol
wonder103617813wonder
wonton93410963wonton
wow96643473w___ow
wynd116114463wynd__
wynds126310373wynd_s

Search took 6 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 Limit1127162715.48620546.1
3Display Results2712710.0763565.8
 (SQL Overall)1786912715.93530108.0
 
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.