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

147 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
towelling136625(None) 
bowelling1566491bowelling
dowelling1466251dowelling
rowelling1366991rowelling
toweling122910371towe_ling
towellings1452891towellings
trowelling1484911trowelling
boweling143410682bowe_ling
doweling13279762dowe_ling
dwelling13368412_dwelling
hovelling1636162hovelling
jewelling2034832jewelling
modelling1336882modelling
roweling122811122rowe_ling
swelling123212752_swelling
telling83321082t__elling
tolling83418562to__lling
totalling1036522totalling
towelings13234692towe_lings
towering122610872towe_ring
troweling1376362trowe_ling
twilling12268672t_willing
upwelling1535232upwelling
welling112920312__welling
yodelling1435192yodelling
belling103825073__belling
bevelling15227453bevelling
bolling103820883bo__lling
bowering142911713bowe_ring
bowling133916493bow__ling
celling103921263__celling
compelling1746553compelling
corbelling1546713corbelling
cordelling1446383cordelling
covelline1446533covelline
cowering142514033cowe_ring
cowling134017413cow__ling
cupelling1436283cupelling
dolling93817373do__lling
dowering132510613dowe_ring
duelling103410733_duelling
dwellings14244213_dwellings
embowelling1952123embowelling
excelling1935643excelling
expelling1936133expelling
felling113321133__felling
fowling143713113fow__ling
fuelling123410153_fuelling
gavelling14286873gavelling
gelling93219763__gelling
grovelling1554163grovelling
gruelling1155603gruelling
helling114623223__helling
hostelling1446163hostelling
houselling1445753houselling
hoveling15189593hove_ling
howling143413163how__ling
impelling1436913impelling
indwelling1543763indwelling
inwalling1385633inwalling
jelling153516613__jelling
jeweling1935483jewe_ling
knelling13319023_knelling
kvelling16146513_kvelling
labelling1238083labelling
levelling13206973levelling
libelling1236873libelling
lolling83415773lo__lling
lowballing1642273lowballing
lowering122210913lowe_ring
melling102822623__melling
modeling12311073mode_ling
monellin1047373monellin_
monellins1147423monellins
morselling1346323morselling
panelling1239073panelling
polling102920383po__lling
pommelling1743613pommelling
powering142210803powe_ring
propelling1556933propelling
quelling18259793_quelling
ravelling13269243ravelling
rebelling122111163rebelling
refelling132211313refelling
repelling122312753repelling
reselling102213833reselling
retelling102112493retelling
revelling132412553revelling
rewelding1436913rewelding
rolling83620413ro__lling
selling83225833__selling
shelling123515213_shelling
shovelling1744063shovelling
smelling113712723_smelling
snelling93913563_snelling
spelling113315233_spelling
swellings13296103_swellings
swilling123511933_swilling
tasselling1145233tasselling
teaselling1145333teaselling
teazelling2043803teazelling
thralling13256833thralling
thrilling13276693thrilling
tilling83522783t__illing
tinselling1145523tinselling
toddling11187003to_ddling
toeing74418473to_e__ing
toggling11206483to_ggling
toileting1036263toileting
toiling83219023to__iling
tokening1336463toke_ning
toling73926123to___ling
tooling82918313to__oling
tootling9279523to_otling
toppling13197353to_ppling
tortellini1053543tortellini
totaling9610303to_taling
tousling938793to_usling
touzling1835503to_uzling
towelled1236353towell_ed
towerlike1643263towerlike
towing103823193tow___ing
towline102911543tow__line
tramelling1346373tramelling
travelling1456533travelling
trebling1139873t_rebling
trilling92815963t_rilling
trolling93212493t_rolling
tunnelling1144383tunnelling
tweaking1635883t_weaking
tweedling1442533tweedling
tweeting12267033t_weeting
tweezing21384113t_weezing
twillings13234913t_willings
twirling12246243t_wirling
unselling10810333unselling
unwilling1337163unwilling
upswelling1643363upswelling
upwellings1641823upwellings
vowelizing2643693vowelizing
walling113520973__walling
welding123213253__welding
welting113615313__welting
willing113821613__willing
yelling113516703__yelling
yodeling1357673yode_ling
yowling143610223yow__ling

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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411477.26620457.1
3Display Results1471470.0632333.3
 (SQL Overall)1786911477.50223819.1
 
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.