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

162 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
towelled123635(None) 
bowelled1446181bowelled
dowelled1356341dowelled
rowelled1236631rowelled
toweled112410221towe_led
trowelled1344441trowelled
boweled132810692bowe_led
doweled12269772dowe_led
dwelled12337592_dwelled
hovelled15146842hovelled
jewelled1934342jewelled
modelled1236432modelled
roweled11269862rowe_led
swelled113211702_swelled
tolled73819032to__lled
totalled935842totalled
towered112911402towe_red
troweled12106112trowe_led
troweller1244562troweller
twilled11398032t_willed
upwelled1434662upwelled
welled103820212__welled
yodelled1334602yodelled
belled94626193__belled
bevelled14327823bevelled
bolled94722653bo__lled
bowelless1443833bowelless
bowered133113043bowe_red
bowled125018143bow__led
celled94420323__celled
compelled1646133compelled
corbelled1446613corbelled
cordelled1346403cordelled
cowered133214653cowe_red
cowled125218393cow__led
cupelled1365743cupelled
dolled83518073do__lled
dowered122811553dowe_red
duelled9359753_duelled
dweller11297273_dweller
embowelled1852103embowelled
excelled18125703excelled
expelled1895883expelled
felled103720303__felled
fowled133914103fow__led
fuelled11369193_fuelled
gabelled12317583gabelled
gavelled13387363gavelled
gelled84718893__gelled
grovelled1454183grovelled
gruelled1034893gruelled
helled104024703__helled
hostelled1345733hostelled
houselled1346203houselled
hoveled14209293hove_led
howled134014973how__led
impelled1336073impelled
inwalled1275773inwalled
jelled144916063__jelled
jeweled1845333jewe_led
jeweller1844133jeweller
jowled174210803jow__led
knelled12338993_knelled
kvelled15276063_kvelled
labelled11278293labelled
lapelled11227083lapelled
levelled12327453levelled
libelled11317213libelled
lolled74315823lo__lled
lowballed1542053lowballed
lowered112711913lowe_red
melled95023023__melled
modeled1139463mode_led
modeller1136613modeller
morelle91210803morelle_
morelles10710493morelles
morselled1245963morselled
novelle1058233novelle_
panelled1138963panelled
polled94022003po__lled
pommelled1643083pommelled
powered132911643powe_red
propelled1456913propelled
quelled17279273_quelled
ravelled12419783ravelled
rebelled113110333rebelled
refelled122810173refelled
repelled113111593repelled
revelled123712743revelled
rewelded1335893rewelded
rolled74220243ro__lled
roselle7310243roselle_
roselles8310713roselles
shelled113815093_shelled
shovelled16174413shovelled
smelled103511863_smelled
snelled83313053_snelled
spelled103714743_spelled
sweller103012473_sweller
swilled113611833_swilled
tasselled1044663tasselled
teaselled1045153teaselled
teazelled1943743teazelled
teller63519823t__eller
thralled1245803thralled
thrilled1235493thrilled
tilled74722953t__illed
tinselled1044423tinselled
toddled10328823to_ddled
toggled10428653to_ggled
toiled74420323to__iled
toileted936993toileted
tokened1236393toke_ned
toled65934923to___led
toller63819443to__ller
tomalley1343283tomalley
tooled74918903to__oled
tootled83511043to_otled
toppled12348843to_ppled
totaled839693to_taled
tousled84710363to_usled
touzled17367153to_uzled
towable121910113towable_
towed95134583tow___ed
towel84920523towe_l__
toweling122910373toweling
towelling1366253towelling
towels94314643towe_l_s
towerier1137123towerier
towheaded1742823towheaded
townlet1049733tow_nlet
tramelled1266223tramelled
travelled1356863travelled
trebled1038483t_rebled
trilled84116313t_rilled
trolled84312263t_rolled
troweler11106063trowe_ler
trowellers1343663trowellers
tunnelled1054583tunnelled
tweaked1534403t_weaked
tweed94915093t_we__ed
tweedled1332833tweedled
tweeted11336583t_weeted
tweezed20274993t_weezed
twelve1234163t_welve_
twelves1334303t_welves
twirled11385983t_wirled
umbelled1336273umbelled
unwalled1288653unwalled
unwelded1337143unwelded
unwilled1277823unwilled
upswelled1542903upswelled
vowelized2543473vowelized
walled104021293__walled
welded114013383__welded
welted103715823__welted
willed104722453__willed
woolled1136643wo_olled
yelled104116253__yelled
yodeled1236863yode_led
yodeller1244853yodeller
yowled133811093yow__led

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621627.17320376.7
3Display Results1621620.0632571.4
 (SQL Overall)1786911627.65623340.0
 
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.