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

343 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
riddling1124944(None) 
diddling12228741diddling
fiddling14217871fiddling
griddling1333931griddling
middling13249341middling
piddling13208951piddling
raddling11229771raddling
reddling112911811reddling
ridding103314191ridd_ing
ridgling11258201ridgling
ruddling11228551ruddling
widdling14228741widdling
addling10229832_addling
bidding123613512bidd_ing
bridling122610582bri_dling
coddling13258472coddling
cuddling13287652cuddling
daddling12258232daddling
dindling112411162dindling
fuddling14247152fuddling
giddying1533782giddying
girdling1146822girdling
huddling14227292huddling
idling8912882_i_dling
kidding14389772kidd_ing
kindling14229622kindling
lidding103611432lidd_ing
meddling13257932meddling
middlings14194312middlings
muddling13268592muddling
noddling11237262noddling
paddling13218642paddling
peddling13217972peddling
pindling122110982pindling
puddling13218032puddling
radding103715002radd_ing
redding103218512redd_ing
reedling102414272reedling
ridgeling12155262ridgeling
ridging104112982ri_dging
ridglings12214182ridglings
riding84325962ri_d_ing
riesling939012riesling
riffling1556112riffling
rifling112815012ri_fling
riling74227972ri__ling
rilling84023622ri_lling
rimpling13219662rimpling
rippling13197572rippling
rivaling1239912rivaling
rodding103814532rodd_ing
saddling11239592saddling
sideling101012182sideling
sidling9915422si_dling
toddling11187002toddling
treddling1234422treddling
trindling1137132trindling
twiddling1543082twiddling
unriddling1342632unriddling
waddling14237932waddling
wildling13248082wildling
windling132212262windling
adding93914963_add_ing
aiding84423613ai_d_ing
ailing74331013ai__ling
bedding124114483bedd_ing
biddings13397563bidd_ings
biding104720793bi_d_ing
bielding12237473bielding
billing103823853bi_lling
binding113819383bind_ing
birding114014923bird_ing
birling104317053bi_rling
boodling121910243boodling
bradding13268933bradd_ing
brandling1348253brandling
bridging13288443bri_dging
brisling112410843bri_sling
bristling1246663bristling
brittling1235543brittling
budding123712403budd_ing
buddying16274793buddying
bundling12219703bundling
caddying16225063caddying
candling122313873candling
circling1338423circling
codding124014693codd_ing
codling114418953_codling
cradling122411453cradling
crimpling1645343crimpling
crinkling16145863crinkling
crippling1644093crippling
crudding1335723crudd_ing
curdling12228893curdling
dandling112511733dandling
dawdling14236373dawdling
dialing94318173di_aling
dialling10310783dialling
dibbling14247333dibbling
diddlies1137593diddlies
dimpling14199023dimpling
dirling93316073di_rling
doling84923133__doling
doodling11218403doodling
dribbling1533713dribbling
drilling103311983dri_lling
driveling1445763driveling
drizzling1943023drizzling
dwindling15123793dwindling
eddying1335293_eddying
fidging133910503fi_dging
fielding13206863fielding
filing103823763fi__ling
filling113520803fi_lling
finding124116543find_ing
fizzling20264993fizzling
fondling13189353fondling
fribbling1733673fribbling
frilling123011493fri_lling
frivoling1644493frivoling
frizzling2153113frizzling
gadding113411453gadd_ing
giggling10227043giggling
gilding103813003gild_ing
gilling93520383gi_lling
girding103611883gird_ing
godding113911943godd_ing
godling103513403_godling
griding103014973gri_d_ing
grilling103811533gri_lling
grinding1139863grind_ing
grizzling1942843grizzling
handling132312713handling
hiding114319333hi_d_ing
higgling14217163higgling
hilding123713533hild_ing
hilling113821773hi_lling
hireling121210993hireling
hirpling1467223hirpling
hirsling1277543hirsling
hondling132210013hondling
hurdling13288013hurdling
induing91910943_induing
inkling122911303_inkling
isling71213883_i_sling
jiggling18226363jiggling
jingling17188573jingling
kibbling17225703kibbling
killing123118723ki_lling
kindlings15195273kindlings
kitling123313573ki_tling
kittling1336063kittling
ladling92813393_ladling
libeling1139873libeling
lordling1077743lordling
madding123711993madd_ing
medaling121912263medaling
miauling1137343miauling
middlingly1842323middlingly
midline102315103mi_dline
milding113615453mild_ing
milling103223683mi_lling
minding113317893mind_ing
mingling122010933mingling
misdoing1238803misdoing
mizzling19255443mizzling
modeling12311073modeling
mudding123310813mudd_ing
muddying16254543muddying
needling10248753needling
nibbling13256503nibbling
nickling15278703nickling
nidating1039783nidating
niddering1255323niddering
nidering10510483nidering
niding83217983ni_d_ing
niggling11227443niggling
nilling83619563ni_lling
nodding103811523nodd_ing
noodling10209443noodling
oiling74925313oi__ling
padding123412513padd_ing
paddlings14224363paddlings
pedaling122412133pedaling
pickling17239203pickling
piffling1745133piffling
piling95025593pi__ling
pilling103722563pi_lling
podding124113183podd_ing
prickling1836533prickling
priding113317543pri_d_ing
prilling113413413pri_lling
prodding13189343prodd_ing
pudding124010803pudd_ing
puddlings14243793puddlings
rabbling13239333rabbling
radioing1039383radioing
raffling1567063raffling
raiding93617593raid_ing
railing83325643r_ailing
rambling131810773rambling
rankling132610113rankling
rassling939013rassling
rattling92510873rattling
raveling123414373raveling
readding11411363readding
reading93327213read_ing
readying13410223readying
rebidding14275463rebidd_ing
redating102620173redating
reddening1237433reddening
redialing11311843redialing
reding83825563r_ed_ing
redline84218833r_edline
redoing93516733r_edoing
redrying13209023redrying
reducing12310203reducing
redwing122811983r_edwing
redyeing1336173redyeing
reeding94124133reed_ing
reedlings11236343reedlings
reeling83126863r_eeling
refiling123116533refiling
regaling10315363regaling
rekindling1643523rekindling
rending93924263rend_ing
reoiling93217213reoiling
resaddling1343503resaddling
resiling93520173resiling
resoling92916303resoling
retiling93319483retiling
reveling123117083reveling
reviling122917213reviling
ribbing123111953ri_bbing
ricing94822763ri__cing
ricking143920233ri_cking
ridden83511723ridd_en_
riddle83915713riddl__e
riddled103012043riddl_ed
riddler93411263riddl_er
riddlers10269103riddlers
riddles93215023riddl_es
ridgeline11174723ridgeline
ridgelings13172993ridgelings
ridiculing1442483ridiculing
ridings93412093ri_d_ings
rieslings1034493rieslings
riffing144011273ri_ffing
riflings12227303ri_flings
rifting113515003ri_fting
rigging103016333ri_gging
righting132610853righting
riming93322223ri__ming
rimming123411073ri_mming
ringing93521283ri_nging
rinning83216743ri_nning
rinsing82516113ri_nsing
rioting82716393ri_oting
ripening1138573ripening
riping93821613ri__ping
ripping123315743ri_pping
rising74025883ri__sing
risking123914243ri_sking
rivalling1335963rivalling
riveting12139443riveting
riving104521423ri__ving
rockling15259383rockling
rodeoing1037253rodeoing
roiling83220453r_oiling
rolling83620413r_olling
rootling9269953rootling
roweling122811123roweling
rubbling13238073rubbling
ruckling15258573ruckling
ruffling1546093ruffling
ruling73219553r__uling
rumbling131910103rumbling
rumpling13178763rumpling
runkling13217613runkling
rustling9249983rustling
sandling102214413sandling
seedling102610953seedling
sibling10814423si_bling
sickling152910333sickling
sideline91011093sideline
sidelong10133983sidelong
siding83822133si_d_ing
singling101913003singling
sizzling17225783sizzling
skidding1535463skidd_ing
sodding103712733sodd_ing
spindling13136273spindling
spraddling1542313spraddling
straddling1343643straddling
swaddling1543813swaddling
swindling14135833swindling
tedding103210883tedd_ing
tickling15309433tickling
tiding83520093ti_d_ing
tidying1238513ti_dying
tiling73426553ti__ling
tilling83522783ti_lling
tingling102210823tingling
tinkling13239233tinkling
tippling13196703tippling
tirling83315733ti_rling
titling83715793ti_tling
treadling1137503treadling
trickling1647723trickling
trifling122411503tri_fling
trilling92815963tri_lling
tripling112712553tri_pling
trundling1135003trundling
twaddling1552713twaddling
vialing113614163vi_aling
vialling1237223vialling
vittling1236143vittling
wadding133711943wadd_ing
waddying17204723waddying
wedding133411873wedd_ing
wedeling1338773wedeling
whidding1734573whidd_ing
widening13237833widening
widowing1635183widowing
wielding13286863wielding
wiggling14217293wiggling
wilding123814293wild_ing
wildlings14244923wildlings
wiling103024293wi__ling
willing113821613wi_lling
wimbling16186543wimbling
wimpling16207483wimpling
winding123517913wind_ing
windlings14236723windlings
winkling16298293winkling
wintling12249923wintling
witling113215813wi_tling
wriggling1533813wriggling
wrinkling17144953wrinkling
yielding13205033yielding
yodeling1357673yodeling
yodling123610253_yodling
zizzling16233923zizzling

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.406440125.6
2DLD Change Limit1461623437.25020160.3
3Display Results3433430.1402450.0
 (SQL Overall)1786913437.79622920.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.