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

243 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
tummlers1229570(None) 
tumblers123110621tumblers
tummler11266611tummler_
bumblers143710732bumblers
bummers133712442bumm_ers
cummers133713482cumm_ers
fumblers15318712fumblers
gummers123712202gumm_ers
humblers15379802humblers
hummers143813062humm_ers
jumblers19358322jumblers
mumblers14328762mumblers
mummers103712842mumm_ers
rumblers123610742rumblers
rummers113513652rumm_ers
stumblers1334382stumblers
summers113616502summ_ers
tumbler113412822tumbler_
tumbles113816022tumble_s
tummies113012032tummie_s
turtlers8258202turtlers
amblers115213563_amblers
bubblers11448943bubblers
bucklers16349503bucklers
buglers105115323bu_glers
bumbler134013233bumbler_
bumbles134016843bumble_s
bummer124014103bumm_er_
bumpers133912053bu_mpers
bundlers11399183bundlers
bunglers11398483bunglers
burblers12399263burblers
burlers94120273bu_rlers
bustlers104210613bustlers
butlers94518053bu_tlers
cuddlers12388383cuddlers
cullers93418853cu_llers
cumbers134515413cu_mbers
cummer124414593cumm_er_
cupelers1266733cupelers
curdlers11368493curdlers
curlers94218073cu_rlers
cutlers94217003cu_tlers
dammers123214273damm_ers
dimmers123811563dimm_ers
drummers13316163drumm_ers
duelers83412053du_elers
duellers9268223duellers
dummies123012133dummie_s
dumpers123412663du_mpers
emmers104013223_emm_ers
fuelers103912393fu_elers
fuellers11277983fuellers
fullers103817373fu_llers
fumbler143610813fumbler_
fumbles143514413fumble_s
fumeless13236603fumeless
fumers113613383fu_m_ers
furlers104214223fu_rlers
gamblers13369733gamblers
gammers123214563gamm_ers
grumblers14245023grumblers
gumless10228273gu_mless
gummer114615453gumm_er_
gummier12349473gummier_
guttlers9306933guttlers
guzzlers17274863guzzlers
hammers144216063hamm_ers
hemmers143310843hemm_ers
huddlers13337633huddlers
hullers103616263hu_llers
humbler143411943humbler_
humbles143215803humble_s
hummer133615273humm_er_
humpers142713523hu_mpers
humpless15226333humpless
hurdlers12337493hurdlers
hurlers103714323hu_rlers
hustlers11349203hustlers
jammers183710703jamm_ers
jugglers17366523jugglers
jumbler183910273jumbler_
jumbles183013323jumble_s
jumpers18399843ju_mpers
kummels15234793kumm_els
limmers113413083limm_ers
lullers73213353lu_llers
lumbers113815913lu_mbers
lumpers113514483lu_mpers
mammers104615693mamm_ers
milers84625163__milers
muddlers12428813muddlers
mufflers16316003mufflers
mullers93217303mu_llers
mumbler133510913mumbler_
mumbles133014433mumble_s
mummer93614543mumm_er_
mummery13336663mumm_ery
mummies103812843mummie_s
mumpers133311373mu_mpers
muzzlers18245203muzzlers
numbers113711243nu_mbers
numbles113814273numble_s
nuzzlers16244753nuzzlers
puddlers12298683puddlers
pulers83820283pu__lers
pullers93618483pu_llers
pumicers1434353pumicers
pummelos14223103pummelos
pummels13236543pumm_els
pumpers133113673pu_mpers
pumpless14236373pumpless
purflers13216963purflers
puzzlers18295143puzzlers
quellers17237533quellers
ramblers124010373ramblers
rammers113715043ramm_ers
rimmers113812883rimm_ers
rufflers14347193rufflers
rulers64317093ru__lers
rumbler113514113rumbler_
rumbles114018393rumble_s
rummagers1443033rummagers
rummer104715483rumm_er_
rummier11309563rummier_
rummies113212793rummie_s
rumples113313133rumple_s
rumpless12256543rumpless
rustlers8339853rustlers
samplers12299403samplers
scummers14277783scumm_ers
simmers113314613simm_ers
slummers12358933slumm_ers
smilers94113853_smilers
stammers123611523stamm_ers
stemmers12378443stemm_ers
strummers1333693strumm_ers
stumbler1235813stumbler_
stumbles1237493stumble_s
stumpers12318313stu_mpers
sucklers14379963sucklers
sumless92611123su_mless
summer104017713summ_er_
summery14329413summ_ery
summoners1344733summoners
sumpters1238023sumpters
sutlers73116973su_tlers
tacklers143010773tacklers
tailers73720183t_ailers
talers64628143t__alers
tamales93216153tamale_s
tameless10259903tameless
tamers84224033t_am_ers
tammies113814683tammie_s
tampers113516743t_ampers
tanglers92911973tanglers
tattlers8369693tattlers
teemers95012903teem_ers
tellers73717593t_ellers
temblors1244463temblors
tempers113513013t_empers
templars1255263templars
temples112610893temple_s
templets12226143templets
tempters12257293tempters
termers95414503term_ers
termless1036233termless
thalers106212263t_halers
thrummers1642413thrumm_ers
thumbless1643433thumbless
thumpers15365713thumpers
ticklers14339303ticklers
tiddlers10288653tiddlers
tilers63523503t__ilers
tillers73418743t_illers
timbers113111853t_imbers
timeless10239543timeless
timers84420993t_im_ers
tinglers93710593tinglers
tinklers12298183tinklers
tipplers12336353tipplers
toddlers10346963toddlers
togglers10276953togglers
toilers74116263t_oilers
tollers73217463t_ollers
tombless1236783tombless
tommies113812983tommie_s
toolers74416503t_oolers
tootlers8289503tootlers
trailers82912923trailers
tramless1037503tramless
trammelers1442513trammelers
trampers123210393trampers
tramplers13305883tramplers
trawlers113310203trawlers
tremblers1334483tremblers
triflers113110213triflers
trillers83613493trillers
trimers94615143trim_ers
trimmers12288913trimmers
trollers83211213trollers
trucklers15295583trucklers
trundlers10215003trundlers
tubbers113411253tu_bbers
tubeless1037023tubeless
tubers85017033tu__bers
tubules9310233tubule_s
tuckers134014353tu_ckers
tufters10298353tu_fters
tuggers93711443tu_ggers
tugless837383tu_gless
tuilles72411923tuille_s
tules54532793tu__le_s
tulles63218893tu_lle_s
tumble103215643tumble__
tumbled123412243tumble_d
tumbrels12285733tumbrels
tumors8810613tu_m_ors
tumours976753tu_mours
tumular9236543tumular_
tumulous1045303tumulous
tumults934823tumul_ts
tumulus935033tumul_us
tuneless837913tuneless
tuners64417343tu__ners
tunnelers953463tunnelers
turfless1135533turfless
turners73912893tu_rners
turtler72610323turtler_
turtles72914343turtle_s
tuskers113710043tu_skers
tuskless1234213tuskless
tussers74313563tu_ssers
tussles737833tussle_s
tutelars844993tutelars
tutoyers1133303tutoyers
tuyers94612563tu__yers
twirlers11274303twirlers
umbers104215213_u_mbers
umbles103817493_umble_s
yammers143410323yamm_ers
yummier14306843yummier_
yummies14359533yummie_s

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.436409841.7
2DLD Change Limit1461622437.12320519.7
3Display Results2432430.0932612.9
 (SQL Overall)1786912437.65223352.2
 
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.