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

305 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
fiddling1421786(None) 
diddling12228731diddling
fuddling14247151fuddling
middling13249331middling
piddling13208941piddling
riddling11249431riddling
widdling14228731widdling
addling10229832_addling
bidding123613502bidd_ing
coddling13258472coddling
cuddling13287652cuddling
daddling12258232daddling
dindling112411162dindling
fidging133910502fi_dging
fielding13206862fielding
filing103823762fi__ling
filling113520802fi_lling
finding124116542find_ing
fizzling20264992fizzling
fondling13189352fondling
giddying1533772giddying
girdling1146822girdling
griddling1333932griddling
huddling14227292huddling
idling8912872_i_dling
kidding14389762kidd_ing
kindling14229622kindling
lidding103611422lidd_ing
meddling13257932meddling
middlings14194302middlings
muddling13268592muddling
noddling11237252noddling
paddling13218642paddling
peddling13217972peddling
pindling122110982pindling
puddling13218032puddling
raddling11229772raddling
reddling112911812reddling
ridding103314182ridd_ing
ridgling11258202ridgling
ruddling11228552ruddling
saddling11239592saddling
sideling101012172sideling
sidling9915422si_dling
toddling11187002toddling
twiddling1543082twiddling
waddling14237932waddling
wildling13248082wildling
windling132212262windling
adding93914963_add_ing
aiding84423613ai_d_ing
ailing74331013ai__ling
bedding124114483bedd_ing
befuddling1841853befuddling
biddings13397553bidd_ings
biding104720793bi_d_ing
bielding12237473bielding
billing103823853bi_lling
binding113819383bind_ing
birding114014923bird_ing
birling104317053bi_rling
boodling121910243boodling
bridling122610583bridling
budding123712403budd_ing
buddying16274793buddying
bundling12219703bundling
caddying16225063caddying
candling122313873candling
circling1338423circling
codding124014693codd_ing
codling114418953_codling
cradling122411453cradling
curdling12228893curdling
dandling112511733dandling
dawdling14236373dawdling
dialing94318173di_aling
dialling10310783dialling
dibbling14247333dibbling
diddlies1137593diddlies
dimpling14199023dimpling
dirling93316073di_rling
doling84923133__doling
doodling11218403doodling
dwindling15123793dwindling
eddying1335293_eddying
fabling133413623f_abling
fadging134210243f_adging
fading114821113f_ad_ing
failing113521333f_ailing
falling113621583f_alling
farding123716743fard_ing
fatling113815683f_atling
fedexing2034493fedexing
feeding123515073feed_ing
feeling113617073f_eeling
felling113321133f_elling
fending123717603fend_ing
feruling1258873feruling
fettling1266773fettling
feuding123410263feud_ing
fibbing15339453fi_bbing
fiddle113613383fiddl__e
fiddled13329633fiddl_ed
fiddler12309953fiddl_er
fiddlers13328283fiddlers
fiddles123212603fiddl_es
fiddly14328483fiddl__y
fidelity1544933fidelity
fidgeting1544513fidgeting
fifing134212343fi__fing
figging133313563fi_gging
fighting162710083fighting
figuline1256033figuline
figuring1336283figuring
filching1736113filching
fileting1239303fileting
filings115213073fi__lings
fillings122910503fi_llings
filming133210353fi_lming
finagling1434703finagling
findings13328433find_ings
finiking16277073finiking
fining104223213fi__ning
finking154016603fi_nking
finning113615113fi_nning
firing104021723fi__ring
firming132811223fi_rming
firstling1334423firstling
fishing143913863fi_shing
fishline14237583fishline
fisting113818123fi_sting
fitting113516563fi_tting
fixating1936183fixating
fixing174813783fi__xing
fizzing19276403fi_zzing
flailing12298923flailing
flatling123410013flatling
fledging14276523fledging
fledgling1552473fledgling
fling97023513f___ling
foaling113515843f_oaling
foddering1535153foddering
foiling113317653f_oiling
folding123912443fold_ing
fonding123815423fond_ing
fondlings14224893fondlings
fonduing13245893fonduing
fooling113117373f_ooling
footling12239923footling
foozling21275723foozling
fording123717033ford_ing
fordoing1357293fordoing
fouling113315373f_ouling
foundling1435203foundling
fowling143713113f_owling
fribbling1733673fribbling
frilling123011493frilling
frivoling1644493frivoling
frizzling2153113frizzling
fudging133310013f_udging
fueling113615133f_ueling
fuelling123410153fuelling
fugling124212513f_ugling
fulling114019703f_ulling
fumbling16208163fumbling
funding124113663fund_ing
furling114016563f_urling
gadding113411453gadd_ing
giggling10227043giggling
gilding103813003gild_ing
gilling93520383gi_lling
girding103611883gird_ing
godding113911943godd_ing
godling103513403_godling
handling132312713handling
hiding114319333hi_d_ing
higgling14217163higgling
hilding123713533hild_ing
hilling113821773hi_lling
hireling121210993hireling
hirpling1467223hirpling
hirsling1277543hirsling
hondling132210013hondling
hurdling13288013hurdling
induing91910943_induing
inkling122911303_inkling
isling71213873_i_sling
jiggling18226363jiggling
jingling17188573jingling
kibbling17225703kibbling
killing123118723ki_lling
kindlings15195263kindlings
kitling123313573ki_tling
kittling1336063kittling
ladling92813393_ladling
libeling1139873libeling
lordling1077743lordling
madding123711993madd_ing
medaling121912243medaling
miauling1137343miauling
middlingly1842323middlingly
midline102315103mi_dline
milding113615453mild_ing
milling103223683mi_lling
minding113317893mind_ing
mingling122010933mingling
misdoing1238803misdoing
mizzling19255443mizzling
modeling12311073modeling
mudding123310813mudd_ing
muddying16254543muddying
needling10248753needling
nibbling13256503nibbling
nickling15278703nickling
nidating1039773nidating
niddering1255313niddering
nidering10510473nidering
niding83217973ni_d_ing
niggling11227443niggling
nilling83619563ni_lling
nodding103811513nodd_ing
noodling10209443noodling
oiling74925313oi__ling
padding123412513padd_ing
paddlings14224353paddlings
pedaling122412133pedaling
pickling17239203pickling
piffling1745133piffling
piling95025593pi__ling
pilling103722563pi_lling
podding124113183podd_ing
pudding124010803pudd_ing
puddlings14243783puddlings
radding103715003radd_ing
redding103218513redd_ing
reedling102414273reedling
ridgeling12155253ridgeling
ridging104112983ri_dging
ridglings12214173ridglings
riding84325963ri_d_ing
riesling939013riesling
riffling1556113riffling
rifling112815013ri_fling
riling74227973ri__ling
rilling84023623ri_lling
rimpling13219663rimpling
rippling13197573rippling
rivaling1239913rivaling
rodding103814533rodd_ing
sandling102214413sandling
seedling102610953seedling
sibling10814423si_bling
sickling152910333sickling
sideline91011093sideline
sidelong10133983sidelong
siding83822133si_d_ing
singling101913003singling
sizzling17225783sizzling
skidding1535463skidd_ing
sodding103712733sodd_ing
spindling13136273spindling
swaddling1543813swaddling
swindling14135833swindling
tedding103210883tedd_ing
tickling15309433tickling
tiding83520093ti_d_ing
tidying1238513ti_dying
tiling73426553ti__ling
tilling83522773ti_lling
tingling102210803tingling
tinkling13239233tinkling
tippling13196703tippling
tirling83315733ti_rling
titling83715793ti_tling
treddling1234423treddling
trindling1137133trindling
twaddling1552713twaddling
unriddling1342633unriddling
vialing113614163vi_aling
vialling1237223vialling
vittling1236143vittling
wadding133711943wadd_ing
waddying17204723waddying
wedding133411873wedd_ing
wedeling1338773wedeling
whidding1734573whidd_ing
widening13237823widening
widowing1635183widowing
wielding13286863wielding
wiggling14217293wiggling
wilding123814293wild_ing
wildlings14244913wildlings
wiling103024293wi__ling
willing113821613wi_lling
wimbling16186533wimbling
wimpling16207483wimpling
winding123517913wind_ing
windlings14236713windlings
winkling16298293winkling
wintling12249923wintling
witling113215813wi_tling
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.1561145455.1
2DLD Change Limit1461623057.61019206.6
3Display Results3053050.1102772.7
 (SQL Overall)1786913057.87622688.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.