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

140 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
dowelling146625(None) 
bowelling1566491bowelling
doweling13279761dowe_ling
dwelling13368411d_welling
rowelling1366991rowelling
towelling1366251towelling
boweling143410682bowe_ling
dolling93817372do__lling
dowering132510612dowe_ring
duelling103410732d_uelling
dwellings14244212d_wellings
hovelling1636162hovelling
jewelling2034832jewelling
modelling1336882modelling
roweling122811122rowe_ling
swelling123212752_swelling
toweling122910372towe_ling
towellings1452892towellings
trowelling1484912trowelling
upwelling1535232upwelling
welling112920312__welling
yodelling1435192yodelling
belling103825073__belling
bevelling15227453bevelling
bolling103820883bo__lling
bowering142911713bowe_ring
bowling133916493bow__ling
celling103921263__celling
compelling1746553compelling
corbelling1546713corbelling
cordelling1446383cordelling
covelline1446533covelline
cowering142514033cowe_ring
cowling134017423cow__ling
cupelling1436283cupelling
dawdling14236373daw_dling
dealing94323233d__ealing
defuelling1573543defuelling
deleing93313953d__eleing
delving123711573d__elving
develing133212733deve_ling
devilling1436703devilling
dewooling1444323dewooling
dialling10310783d_ialling
disbowelling1952063disbowelling
dispelling1447613dispelling
dogearing1235763dogearing
doling84923133do___ling
dollying13407423do_llying
doodling11218403do_odling
doubling1238153do_ubling
dovening13238353dove_ning
dowelled1356343dowell_ed
dowing114221513dow___ing
downing123811673dow__ning
downlink1644523dow_nlink
downswing1743043downswing
dowsing123411123dow__sing
dozening19236183doze_ning
drilling103311983d_rilling
drivelling1543983drivelling
drolling103510763d_rolling
drywalling1842233drywalling
dueling93614543d_ue_ling
dulling93418273d__ulling
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
lolling83415783lo__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
telling83321083__telling
tolling83418563to__lling
totalling1036523totalling
towelings13234693towe_lings
towering122610873towe_ring
troweling1376363trowe_ling
twilling12268673_twilling
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.423422437.4
2DLD Change Limit1486411406.86021667.8
3Display Results1401400.0463043.5
 (SQL Overall)1786911407.32924381.4
 
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.