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

148 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
bowelling156649(None) 
boweling143410691bowe_ling
dowelling1466251dowelling
rowelling1366991rowelling
towelling1366251towelling
belling103825072b__elling
bevelling15227452bevelling
bolling103820882bo__lling
bowering142911722bowe_ring
bowling133916492bow__ling
doweling13279772dowe_ling
dwelling13368412_dwelling
embowelling1952122embowelling
hovelling1636162hovelling
jewelling2034832jewelling
modelling1336882modelling
roweling122811132rowe_ling
swelling123212752_swelling
toweling122910382towe_ling
towellings1452892towellings
trowelling1484912trowelling
upwelling1535232upwelling
welling112920312__welling
yodelling1435192yodelling
balling104424763b__alling
barrelling1345453barrelling
bawling133813863baw__ling
beetling1139283b_eetling
befalling15226503befalling
begalling13216493begalling
bejewelling2451443bejewelling
bellings113811153b__ellings
bellying14359073b__ellying
belting104119133b__elting
belying133612443b__elying
beveling143011033beve_ling
bewailing1536063bewailing
beweeping1743933beweeping
bielding12237473b_ielding
billing103823853b__illing
bobbling12238643bo_bbling
bogeying1575713boge_ying
boggling13257163bo_ggling
boiling103819673bo__iling
bolting104416763bo__lting
boodling121910243bo_odling
bookselling1852263bookselling
bottling11279143bo_ttling
bowelled1446183bowell_ed
bowelless1443833bowelless
bowing124723063bow___ing
bowline123613113bow__line
bowlings14408753bow__lings
bowllike1734863bow_llike
bowsing134012503bow__sing
bowstring15165123bowstring
bowwowing1742133bowwowing
brailling1247773brailling
bulling104324793b__ulling
bushelling1644063bushelling
celling103921263__celling
compelling1746553compelling
corbelling1546713corbelling
cordelling1446383cordelling
covelline1446533covelline
cowering142514053cowe_ring
cowling134017433cow__ling
cupelling1436283cupelling
disbowelling1952063disbowelling
dolling93817373do__lling
dowering132510623dowe_ring
duelling103410733_duelling
dwellings14244213_dwellings
emboweling1863013embowe_ling
excelling1935643excelling
expelling1936133expelling
felling113321133__felling
fowling143713113fow__ling
fuelling123410153_fuelling
gavelling14286893gavelling
gelling93219763__gelling
grovelling1554163grovelling
gruelling1155603gruelling
helling114623223__helling
hostelling1446163hostelling
houselling1445753houselling
hoveling15189603hove_ling
howling143413163how__ling
impelling1436913impelling
indwelling1543763indwelling
inwalling1385633inwalling
jelling153516613__jelling
jeweling1935483jewe_ling
knelling13319023_knelling
kvelling16146513_kvelling
labelling1238103labelling
levelling13206983levelling
libelling1236883libelling
lolling83415783lo__lling
lowballing1642273lowballing
lowering122210923lowe_ring
melling102822633__melling
modeling12311083mode_ling
monellin1047373monellin_
monellins1147423monellins
morselling1346323morselling
panelling1239093panelling
polling102920383po__lling
pommelling1743613pommelling
powering142210813powe_ring
propelling1556933propelling
quelling18259793_quelling
ravelling13269263ravelling
rebelling122111163rebelling
refelling132211313refelling
repelling122312753repelling
reselling102213833reselling
retelling102112503retelling
revelling132412553revelling
rewelding1436913rewelding
rolling83620413ro__lling
selling83225833__selling
shelling123515213_shelling
shovelling1744063shovelling
smelling113712733_smelling
snelling93913563_snelling
spelling113315233_spelling
swellings13296103_swellings
swilling123511933_swilling
telling83321093__telling
tolling83418563to__lling
totalling1036523totalling
towelings13234703towe_lings
towering122610883towe_ring
troweling1376363trowe_ling
twilling12268673_twilling
unselling10810333unselling
unwilling1337163unwilling
upswelling1643363upswelling
upwellings1641823upwellings
vowelizing2643693vowelizing
walling113520973__walling
welding123213253__welding
welting113615313__welting
willing113821613__willing
yelling113516703__yelling
yodeling1357683yode_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.483369960.7
2DLD Change Limit1486411486.67322275.0
3Display Results1481480.0632349.2
 (SQL Overall)1786911487.21924752.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.