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

265 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
willows1329975(None) 
billows123611291billows
pillows122610121pillows
wallows133613531wallows
willow12369691willow_
willowy16276351willowy
allows94517682_allows
bellows124313302bellows
billons93013362billons
billow114111222billow_
billowy15366902billowy
fallows133713972fallows
fellows134212432fellows
fillos94415082fillo_s
follows13409922follows
gallows113513512gallows
hallows134417392hallows
hilloas104413552hilloas
hilloes103815962hilloes
hillos94618892hillo_s
hollows134412332hollows
mallows123714322mallows
mellows123812232mellows
pillow113110572pillow_
pillowy15316422pillowy
sallows103915552sallows
swallows14295892swallows
tallows103313742tallows
villous102810022villous
wallops123410412wallops
wallow123913512wallow_
whitlows1743082whitlows
widows1376562wi_dows
willers103517912willers
willets104414322willets
willies103920152willies
willowed15156762willowed
willower14127452willower
willowers15166692willowers
wills84528962will__s
windows1447742windows
winnows1334532winnows
yellows13329602yellows
airflows1443833airflows
airglows1243463airglows
allods73615083_allods
allots64019173_allots
allow85420663_allow_
alloys94014563_alloys
ballons93916963ballons
ballots94116033ballots
barlows12259973barlows
bellow114213353bellow_
belows114614183_belows
bilboas11438733bilboas
bilboes114410243bilboes
bilbos105011203bilbo_s
bilious9310933bilious
billers94720833billers
billets94516153billets
billies93923503billies
billions102211793billions
billon83713833billo_n
billowed14137063billowed
bills75632863bill__s
blows105423833__blows
brillos9369183brillo_s
bullous9311663bullous
callous93516603callous
callow114714663callow_
cellos84517803cello_s
collops112611753collops
dialogs938103dialogs
diglots9299503diglots
dildoes9229243dildoes
dildos8179303dildo_s
dillies84122163dillies
dills65530973dill__s
diploes101111493diploes
disallows1343393disallows
dollops10287963dollops
elbows1196713_elbows
fallow124713853fallow_
felloes104114383felloes
fellow123712743fellow_
fillers104320213fillers
filles94224523fill_es
fillets103414753fillets
fillies103420253fillies
fillips12298133fillips
fillo84319783fillo__
fills84632373fill__s
filos86125383fi_lo_s
flows115822363__flows
follow124010353follow_
gallons83015953gallons
gallops103211653gallops
gallous82813953gallous
giglots9367863giglots
gillers84216903gillers
gillies84120963gillies
gills64728193gill__s
glows95518033__glows
halloas104318463halloas
halloes104021523halloes
halloos103716743halloos
hallos95425103hallo_s
hallow124818323hallow_
helloes103717463helloes
hellos95321683hello_s
hillers103718733hillers
hillo84721653hillo__
hilloa94713033hillo_a
hillock1646693hillock
hillocks1736063hillocks
hilloed113211293hilloed
hills85431353hill__s
hilltops1344933hilltops
holloas103814943holloas
holloes103818193holloes
holloos104013583holloos
hollos95320633hollo_s
hollow124212663hollow_
hulloas103911913hulloas
hulloes104113923hulloes
hulloos104010073hulloos
hullos94916293hullo_s
igloos738033_igloos
ills47030423_ill__s
indows104210793_indows
inflows1335523inflows
jellos134714283jello_s
jillions15178283jillions
jills125122823jill__s
killers114215583killers
killies113318113killies
killjoys2242033killjoys
killock1255253killock
killocks1354793killocks
kills94526173kill__s
kilos95021473ki_lo_s
lilos55821873li_lo_s
lollops9227443lollops
lows75843013___lows
maillots1037473maillots
mallow114014743mallow_
mellow114112223mellow_
miaows1145473mi_aows
mildews13365883mildews
millers93621343millers
milles84526563mill_es
millets94216843millets
millions101712433millions
mills75435053mill__s
milos75428013mi_lo_s
minnows1234913minnows
niellos736143niello_s
nills54926673nill__s
pallors9314363pallors
pilaws11399433pi_laws
pileous9510523pileous
pillars9313493pillars
pillions101610923pillions
pillory12247453pillory
pillowed14156383pillowed
pills74130973pill__s
pilots84018873pi_lots
pilous84717753pi_lous
plows105419903__plows
reflows13258983reflows
reglows11288843reglows
replows12329703replows
rilles64725503rill_es
rillets74216153rillets
rills55032713rill__s
sallow94315753sallow_
sallowy13369343sallowy
shallows14388863shallows
siglos7311473siglo_s
sillers73822103sillers
sillies73425083sillies
sills55135993sill__s
silos56029433si_lo_s
slows85323463__slows
swallow13355753swallow_
swillers11299113swillers
swills94213363swill__s
tallols73311363tallols
tallow93714203tallow_
tallowy13347633tallowy
tiglons837343tiglons
tillers73418743tillers
tills54631713till__s
twills9489793twill__s
upflows1543513upflows
villas96117263vill_as
villose1038053villose
vills86429323vill__s
villus93611223vill_us
wallahs13409473wallahs
wallas95719393wall_as
wallets103914833wallets
wallies103320743wallies
wallop113310293wallo_p
wallowed15148163wallowed
wallower14158933wallower
wallowers15127653wallowers
walls85529383wall__s
weblogs1334223weblogs
weldors11238003weldors
wellies103719073wellies
wells85426193well__s
whitlow1642853whitlow_
widow1278933wi_dow_
wields10469623wiel_ds
wigeons1136983wigeons
wigless11359673wigless
wiglets113411423wiglets
wilco1039443wilco__
wilders113513503wilders
wildfowl1842243wildfowl
wildfowls1952083wildfowls
wilds94818203wi_l_ds
wiles85437873wi_l_es
will75737513will___
willed104722453will_ed
willer94021063will_er
willet95124833will_et
willful1344533willful
willie94116453will_ie
willied114611563willied
willing113821613willing
williwau1452723williwau
williwaus1542463williwaus
williwaw1342323williwaw
williwaws1442253williwaws
willowier1563783willowier
willowiest1643233willowiest
willowing1645323willowing
willpower1773183willpower
willpowers1842893willpowers
willy115321913will__y
willywaw1641943willywaw
willywaws1752013willywaws
wilts85023503wi_l_ts
window1347363window_
windowy1744643windowy
windrows1546163windrows
wingbows1743983wingbows
winless103212283winless
winnow1234593winnow_
winoes94317013wi_noes
winos84625043wi_no_s
wisdoms1335453wisdoms
witless103310983witless
witloof1344353witloof
witloofs1442503witloofs
wittols1035733wittols
wows104633493w___ows
yellow12429883yellow_
yellowy16255693yellowy
yills83921553yill__s
zillahs1935383zillahs
zillions17168073zillions
zills144020783zill__s

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.1561145455.1
2DLD Change Limit1340272656.31321230.3
3Display Results2652650.0763486.8
 (SQL Overall)1786912656.54527301.9
 
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.