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

327 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
willow1236969(None) 
billow114111221billow
pillow113110571pillow
wallow123913511wallow
willows13299751willows
willowy16276351willowy
allow85420662_allow
bellow114213352bellow
billon83713832billon
billows123611292billows
billowy15366902billowy
callow114714662callow
fallow124713852fallow
fellow123712742fellow
fillo84319782fillo_
fillos94415082fillos
follow124010352follow
hallow124818322hallow
hillo84721652hillo_
hilloa94713032hilloa
hillos94618892hillos
hollow124212662hollow
mallow114014742mallow
mellow114112222mellow
pillows122610122pillows
pillowy15316422pillowy
sallow94315752sallow
swallow13355752swallow
tallow93714202tallow
wallop113310292wallop
wallows133613532wallows
whitlow1642852whitlow
widow1278932wi_dow
wilco1039442wilco_
will75737512will__
willed104722452willed
willer94021062willer
willet95124832willet
willie94116452willie
willowed15156762willowed
willower14127452willower
wills84528962will_s
willy115321912will_y
window1347362window
winnow1234592winnow
yellow12429882yellow
aglow94711973_aglow
airflow1343543airflow
airglow1143673airglow
allod64418383_allod
allot54933873_allot
allows94517683_allows
alloy85519973_alloy
alow75328593__alow
ballon84117493ballon
ballot84624093ballot
barlow112911423barlow
bellows124313303bellows
below104617193_below
bilbo95513613bilbo_
bilboa10367843bilboa
bilbos105011203bilbos
bill67239943bill__
billed94224903billed
biller84923483biller
billet86029723billet
billie85019173billie
billion92212173billion
billons93013363billons
billowed14137063billowed
bills75632863bill_s
billy105525363bill_y
blow95827193__blow
bollox1548743bollox
brillo84211003brillo_
brillos9369183brillos
cello74919583cello_
cellos84517803cellos
collop107312313collop
dialog837973dialog
diglot83014333diglot
dildo71911773dildo_
dildoe8198673dildoe
dildos8179303dildos
dill55239973dill__
dilled84122223dilled
dills65530973dill_s
dilly94923783dill_y
diploe9810153diploe
disallow1243513disallow
dollop9259363dollop
elbow10117703_elbow
fallows133713973fallows
felloe93513923felloe
fellows134212433fellows
fill75540193fill__
fille84327403fill_e
filled104922263filled
filler94623623filler
filles94224523filles
fillet95027083fillet
fillip11268953fillip
fills84632373fill_s
filly114424903fill_y
filo76034283fi_lo_
filos86125383fi_los
flow105924923__flow
follows13409923follows
gallon73715813gallon
gallop93311383gallop
gallows113513513gallows
giglot84013133giglot
gill56336183gill__
gilled84521633gilled
giller74519733giller
gillie74816943gillie
gills64728193gill_s
gilly94321633gill_y
glow85222523__glow
hallo85127553hallo_
halloa94918123halloa
halloo95118973halloo
hallos95425103hallos
hallot95426783hallot
hallows134417393hallows
hello86522983hello_
hellos95321683hellos
hill76439493hill__
hilled104022223hilled
hiller94421633hiller
hilloas104413553hilloas
hillock1646693hillock
hilloed113211293hilloed
hilloes103815963hilloes
hills85431353hill_s
hilltop1244783hilltop
hilly114422163hill_y
hollo84822163hollo_
holloa94914823holloa
holloo94415253holloo
hollos95320633hollos
hollows134412333hollows
hullo84417453hullo_
hulloa95011183hulloa
hulloo94511733hulloo
hullos94916293hullos
igloo6410493_igloo
ill37437093_ill__
iller54821293_iller
ills47030423_ill_s
illy76925333_ill_y
indow95011663_indow
inflow1235293inflow
jello126716273jello_
jellos134714283jellos
jill116430263jill__
jillion14188933jillion
jills125122823jill_s
kill85533173kill__
killed113918773killed
killer104917953killer
killie104114893killie
killjoy2142343killjoy
killock1255253killock
kills94526173kill_s
kilo86028663ki_lo_
kilos95021473ki_los
lilo46731563li_lo_
lilos55821873li_los
lollop8238783lollop
low66051873___low
maillot9312173maillot
mallows123714323mallows
mellows123812233mellows
miaow1058353mi_aow
mildew12319043mildew
mill66541483mill__
mille75029133mill_e
milled94326173milled
miller84625413miller
milles84526563milles
millet84030743millet
million91813143million
mills75435053mill_s
milo65536103mi_lo_
milos75428013mi_los
minnow1135583minnow
niello636603niello_
niellos736143niellos
nill45634303nill__
nilled73919453nilled
nills54926673nill_s
pallor8313673pallor
pilaw103913743pi_law
pill65339463pill__
pillar8314023pillar
pillbox1843413pillbox
pilled94222753pilled
pillion92011703pillion
pillory12247453pillory
pillowed14156383pillowed
pills74130973pill_s
pilot77435063pi_lot
plow95923233__plow
reflow12379653reflow
reglow10339403reglow
replow114210343replow
rill45140903rill__
rille55728733rill_e
rilled74525653rilled
rilles64725503rilles
rillet64828853rillet
rills55032713rill_s
sallows103915553sallows
sallowy13369343sallowy
shallow13388873shallow
sigloi737743sigloi
siglos7311473siglos
sill45545153sill__
siller64026063siller
sills55135993sill_s
silly84527613sill_y
silo46037913si_lo_
silos56029433si_los
slow77729493__slow
swallows14295893swallows
swill83417373swill__
swilled113611833swilled
swiller103211663swiller
swills94213363swill_s
tallol63612223tallol
tallows103313743tallows
tallowy13347633tallowy
tiglon737923tiglon
till45941203till__
tilled74722953tilled
tiller64222543tiller
tills54631713till_s
twill85612723twill__
twilled11398033twilled
twills9489793twill_s
upflow1433523upflow
vill75235073vill__
villa85321233vill_a
villae95615383villae
villas96117263villas
villi86517853vill_i
villose1038053villose
villous102810023villous
vills86429323vill_s
villus93611223villus
wall76236103wall__
walla85321033wall_a
wallah124011993wallah
wallas95719393wallas
walled104021293walled
wallet93327093wallet
wallie93216803wallie
wallops123410413wallops
wallowed15148163wallowed
wallower14158933wallower
walls85529383wall_s
wally114625093wall_y
weblog1234223weblog
weldor10317653weldor
well75832043well__
welled103820213welled
wellie92814913wellie
wells85426193well_s
welly114620013well_y
whilom1436133whilom
whitlows1743083whitlows
widows1376563wi_dows
wield95213913wiel_d
wields10469623wields
wieldy13476183wieldy
wigeon1037223wigeon
wiglet105519153wiglet
wild85126513wi_l_d
wilded113714503wilded
wilder103616473wilder
wildfowl1842243wildfowl
wildly13328123wildly
wilds94818203wi_lds
wile75944373wi_l_e
wiled95231553wi_led
wiles85437873wi_les
wilful1235963wilful
wilier93217073wilier
wilily123310763wilily
wiling103024293wiling
willers103517913willers
willets104414323willets
willful1344533willful
willied114611563willied
willies103920153willies
willing113821613willing
williwau1452723williwau
williwaw1342323williwaw
willowers15166693willowers
willowier1563783willowier
willowing1645323willowing
willpower1773183willpower
willywaw1641943willywaw
wilt76246293wi_l_t
wilted103915713wilted
wilts85023503wi_lts
wily106428813wi_l_y
windows1447743windows
windowy1744643windowy
windrow1445853windrow
wingbow1643773wingbow
winnows1334533winnows
wino75933613wi_no_
winos84625043wi_nos
wisdom1235983wisdom
witloof1344353witloof
wittol935923wittol
wow96643473w___ow
yellows13329603yellows
yellowy16255693yellowy
yill75628973yill__
yills83921553yill_s
zill135727613zill__
zillah1836563zillah
zillion16188773zillion
zills144020783zill_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.1401276364.3
2DLD Change Limit1127163275.53320371.6
3Display Results3273270.1102972.7
 (SQL Overall)1786913275.78330899.4
 
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.