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

264 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
fumblers1531871(None) 
bumblers143710731bumblers
fumbler143610811fumbler_
fumbles143514411fumble_s
humblers15379801humblers
jumblers19358321jumblers
mumblers14328761mumblers
rumblers123610741rumblers
tumblers123110621tumblers
amblers115213562_amblers
bubblers11448942bubblers
bumbler134013232bumbler_
bumbles134016842bumble_s
burblers12399262burblers
cumbers134515392cumb_ers
fablers124812612f_ablers
fimbles143510652fimble_s
fuelers103912392fu_elers
fuellers11277982fuellers
fullers103817372fu_llers
fumble133214262fumble__
fumbled153710492fumble_d
fumeless13236602fumeless
fumers113613382fum__ers
furlers104214222fu_rlers
gamblers13369732gamblers
grumblers14245022grumblers
humbler143411942humbler_
humbles143215802humble_s
jumbler183910272jumbler_
jumbles183013322jumble_s
lumbers113815912lumb_ers
mumbler133510912mumbler_
mumbles133014432mumble_s
numbers113711242numb_ers
numbles113814272numble_s
ramblers124010372ramblers
rumbler113514112rumbler_
rumbles114018392rumble_s
stumblers1334372stumblers
tumbler113412822tumbler_
tumbles113816022tumble_s
tummlers12295702tummlers
umbers104215202_umb_ers
umbles103817482_umble_s
ambeers11428923_ambeers
ambers104519563_amb_ers
ambler104916443_ambler_
ambles105121853_amble_s
babblers113510353babblers
bombers134512593bomb_ers
bomblets1436023bomblets
bubbler103611783bubbler_
bubbles104315963bubble_s
bucklers16349503bucklers
buglers105115323bu_glers
bulblets1255353bulblets
bumble124216893bumble__
bumbled144113043bumble_d
bummers133712443bum_mers
bumpers133912053bum_pers
bundlers11399183bundlers
bunglers11398483bunglers
burbler114412423burbler_
burbles114916803burble_s
burlers94120273bu_rlers
bustlers104210613bustlers
butlers94518053bu_tlers
cablers114416713_cablers
cambers134017433camb_ers
clumbers143910393clumb_ers
cobblers14359593cobblers
combers134516613comb_ers
crumbers14338223crumb_ers
crumbles14329683crumble_s
cubers105318343cu_b_ers
cuddlers12388383cuddlers
cullers93418843cu_llers
cumber124016703cumb_er_
cumberers15175993cumberers
cummers133713473cum_mers
cupelers1266733cupelers
curbers115514373curb_ers
curdlers11368493curdlers
curlers94218063cu_rlers
cutlers94216993cu_tlers
cymbalers1842833cymbalers
dabblers13379363dabblers
dibblers13377583dibblers
doublers11288493doublers
drumbles13277723drumble_s
dubbers124011823du_bbers
duelers83412053du_elers
duellers9268223duellers
dumber114414173dumb_er_
dumbness1334613dumbness
dumpers123412663dum_pers
embers104116173_emb_ers
emblems1335043_emblems
enablers10196913enablers
fabler116115813f_abler_
fables114921673f_able_s
fallers103917993f_allers
fameless13259203fameless
feebler1235823feebler_
feelers103814743f_eelers
fellers104117543f_ellers
females12310663female_s
fibbers144510603f_ibbers
fibers114717523f_ib_ers
fiddlers13328283fiddlers
filers94623723f__ilers
fillers104320203f_illers
fimble133611743fimble__
flubbers15346893flubbers
foibles1238853foible_s
fondlers12338023fondlers
footlers113910793footlers
foozlers20346073foozlers
fowlers133411203f_owlers
fribblers16314193fribblers
frillers11349863frillers
fuckers163611593fu_ckers
fuddles123611933fuddle_s
fuehrers1442613fuehrers
fueler94313933fu_eler_
fueller10279963fueller_
fugles104715783fu_gle_s
fuhrers1334813fu_hrers
fuller94220383fu_ller_
fullery13337973fu_llery
fumbling16208163fumbling
fumer105918233fum__er_
fumes105224703fum__e_s
fumets114311813fum__ets
fumier11310903fum_ier_
fumulus1234443fumul_us
funders113813933fu_nders
funkers143712063fu_nkers
furler93616403fu_rler_
furless103210143fu_rless
furriers11369483furriers
furthers1436493furthers
fuseless11237233fuseless
fusileers1242703fusileers
fusiliers1243703fusiliers
fussers104210813fu_ssers
gabblers134110083gabblers
gambiers13337073gambiers
gambler123612683gambler_
gambles124016203gamble_s
garblers113810283garblers
gobblers13308343gobblers
grumbler13866683grumbler_
grumbles13288873grumble_s
gumless10228273gum_less
gummers123712193gum_mers
guttlers9306923guttlers
guzzlers17274863guzzlers
hobblers15308513hobblers
huddlers13337633huddlers
hullers103616263hu_llers
humble133615053humble__
humbled153711813humble_d
humblest15288283humblest
hummers143813063hum_mers
humpers142713523hum_pers
humpless15226333humpless
hurdlers12337493hurdlers
hurlers103714323hu_rlers
hustlers11349203hustlers
jugglers17366523jugglers
jumble174012653jumble__
jumbled19379963jumble_d
jumpers18399843jum_pers
lambers113817103lamb_ers
limbers113614723limb_ers
limbless12246313limbless
lubbers113913723lu_bbers
lullers73213353lu_llers
lumbars11289763lumb_ars
lumber103817773lumb_er_
lumberers13196013lumberers
lumpers113514483lum_pers
marblers12319233marblers
members13258603memb_ers
milers84625163__milers
muddlers12428803muddlers
mufflers16316003mufflers
mullers93217303mu_llers
mumble123614343mumble__
mumbled143010763mumble_d
mummers103712843mum_mers
mumpers133311363mum_pers
muzzlers18245203muzzlers
nibblers12306543nibblers
nimbler11358053nimbler_
nobblers12318563nobblers
nombles113212343nomble_s
nubbles113412433nubble_s
number103913223numb_er_
numberers13165153numberers
numbness1234413numbness
nuzzlers16244753nuzzlers
ombers104214393_omb_ers
outbless1037963outbless
plumbers14418513plumb_ers
puddlers12298683puddlers
pulers83820283pu__lers
pullers93618483pu_llers
pumicers1434353pumicers
pumpers133113673pum_pers
pumpless14236373pumpless
purflers13216963purflers
puzzlers18295143puzzlers
quellers17237533quellers
quibblers2242453quibblers
rabblers123810853rabblers
rambler113313263rambler_
rambles113118313ramble_s
rubbers113913183ru_bbers
rubbles113715113rubble_s
rubles83921703ru_ble_s
rufflers14347193rufflers
rulers64317093ru__lers
rumble103718813rumble__
rumbled124514593rumble_d
rummers113513653rum_mers
rumples113313133rumple_s
rumpless12256543rumpless
rustlers8339853rustlers
samplers12299403samplers
scumbles1447023scumble_s
slumbers123110273slumb_ers
smilers94113843_smilers
stablers103611143stablers
stumbler1235813stumbler_
stumbles1237493stumble_s
subers85722643su_b_ers
sublets92616703su_blets
sucklers14379963sucklers
sumless92611123sum_less
summers113616503sum_mers
sumpters1238023sumpters
sutlers73116973su_tlers
temblors1244443temblors
thumbless1643423thumbless
timbers113111833timb_ers
tombless1236773tombless
tremblers1334473tremblers
tubbers113411243tu_bbers
tubers85017023tu_b_ers
tumble103215643tumble__
tumbled123412243tumble_d
tumbrels12285733tumbrels
tummler11266613tummler_
turtlers8258203turtlers
umbels104510583_umb_els
umber94617583_umb_er_
wabblers15398993wabblers
wambles143714023wamble_s
warblers13319103warblers
wimbles143010843wimble_s
wobblers15327883wobblers

Search took 9 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.1731032896.0
2DLD Change Limit1461622647.70318974.7
3Display Results2642640.1102400.0
 (SQL Overall)1786912647.98622375.5
 
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.