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

395 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
mottlers1038818(None) 
bottlers103810011bottlers
mottler94410341mottler_
mottles93415801mottle_s
battlers104110972battlers
bottler94211882bottler_
bottles94216272bottle_s
cotters94323442cott_ers
cottiers10399152cottiers
dotters83715972dott_ers
dottles83912282dottle_s
footlers113910792footlers
guttlers9306932guttlers
hostlers113310482hostlers
jostlers15357682jostlers
jotters143413802jott_ers
lotters73921062lott_ers
matters94421752matt_ers
mettles94115022mettle_s
modelers1138462modelers
moilers93615202mo_ilers
molters93816972molt_ers
mooters93818622moot_ers
mothers123717622mo_thers
motiles93317432motile_s
motleys1235682mo_tleys
mottes85523692mott_e_s
mottle84116052mottle__
mottled10409972mottle_d
mottoes93412192mottoe_s
moulters103510782moulters
mouthers133811302mouthers
mutters94117142mutt_ers
nettlers8307512nettlers
ostlers72911202_ostlers
otters64021512_ott_ers
potters94024342pott_ers
pottles93816982pottle_s
rattlers83510292rattlers
rotters74421392rott_ers
settlers8289022settlers
tattlers8369692tattlers
tootlers8289502tootlers
totters74618732tott_ers
antlers74014743_antlers
batters94626013batt_ers
battler94113383battler_
battles94517683battle_s
beetlers1037393beetlers
betters94422093bett_ers
bitters94920363bitt_ers
blotters104110983blott_ers
boaters93419243boat_ers
bogglers12347603bogglers
boilers93417063bo_ilers
bolters94017803bolt_ers
boltless10338283boltless
boodlers113710743boodlers
bootlegs11325873bootlegs
bootless103410983bootless
botchers153511543botchers
bothers124317753bo_thers
bottle84916073bottle__
bottled104611233bottle_d
bottomers1344353bottomers
bowlers123715783bo_wlers
bustlers104210613bustlers
butlers94518053_butlers
butters94521723butt_ers
chortlers14305663chortlers
coalers94419353co_alers
coaters93525793coat_ers
coatless1039693coatless
cobblers14359593cobblers
coddlers12359173coddlers
coilers93619903co_ilers
colters93522443colt_ers
coolers93522493co_olers
cooters94525723coot_ers
copters113621283copt_ers
corulers1039773corulers
costers94128333cost_ers
costless10310003costless
cottagers12305383cottagers
cottars94412243cott_ars
cotter84926673cott_er_
cottier93814173cottier_
coulters103614313coulters
couplers123311323couplers
couters93827303cout_ers
cutlers94217003_cutlers
cutters94218963cutt_ers
cuttles93613923cuttle_s
doodlers10338843doodlers
doters74423913do_t_ers
dottels8327783dott_els
dotter74419343dott_er_
dottier83910923dottier_
dottle74212503dottle__
dottrels963493dottrels
doublers11288503doublers
emitters10349643emitt_ers
emoters94712873emo_t_ers
fetters103517903fett_ers
fettles103912733fettle_s
fitters104517753fitt_ers
fondlers12338023fondlers
footers104618333foot_ers
footler104011873footler_
footles103715713footle_s
footless113710803footless
foozlers20346073foozlers
fosters104220103fost_ers
fowlers133411203fo_wlers
getters84216103gett_ers
gobblers13308343gobblers
gogglers11276713gogglers
goiters84014443goit_ers
gutters83715513gutt_ers
guttler8369163guttler_
guttles83011933guttle_s
hatters104221523hatt_ers
hitters104717593hitt_ers
hobblers15308513hobblers
hollers103818233ho_llers
hooters104520473hoot_ers
hostelers1246633hostelers
hostler103411023hostler_
hoteliers1245803hoteliers
hotter94720083hott_er_
hotties103016963hottie_s
howlers133312353ho_wlers
hustlers11349203hustlers
jitters144314473jitt_ers
jogglers17356883jogglers
jolters143711993jolt_ers
jostler14288223jostler_
jostles143411143jostle_s
jotter134315633jott_er_
kettles113411613kettle_s
kittler11338163kittler_
kittles113012493kittle_s
knotters12276153knott_ers
kotowers1534313kotowers
letters73819853lett_ers
litters73422573litt_ers
littler7348553littler_
littles73212783little_s
loathers113310443loathers
lofters103912903loft_ers
loftless1135903loftless
loiters74116613loit_ers
lollers72713793lo_llers
looters74419163loot_ers
lotter64025603lott_er_
lottery10389833lott_ery
lottes65322753lott_e_s
mailers94420333m_ailers
manglers113311903manglers
mantles94820703mantle_s
mantlets104611203mantlets
marblers12319233marblers
martlets103310483martlets
masters94628923mast_ers
mastless102610023mastless
matchers153012433matchers
mateless102711293mateless
maters85032393m_at_ers
matless93014043m_atless
matter84325343matt_er_
mattery123810713matt_ery
mattes85624533matt_e_s
mattress1036533mattress
maturers1037373maturers
maulers94213303m_aulers
meatless103410863meatless
meddlers12318203meddlers
meeters94714543meet_ers
melters93918313melt_ers
metamers1249623metamers
meters85625833m_et_ers
metiers93312843m_etiers
mettle83815723mettle__
mettled103510543mettle_d
mewlers12288983m_ewlers
middlers123410193middlers
milers84625163m__ilers
millers93621343m_illers
milters93619093milt_ers
minglers113011293minglers
minters93822473mint_ers
misters93927513mist_ers
miterers10219683miterers
miters84328783m_it_ers
mithers123516733m_ithers
mittens9349883mitt_ens
moaners92813553mo_aners
mobbers133610923mo_bbers
mobiles112813123mobile_s
mobsters12359063mobsters
mockers153812943mo_ckers
modeler1039293modeler_
modellers1245393modellers
modulars1165833modulars
modules102511003module_s
moiler84017263mo_iler_
molars85517323mo__lars
molders103315553mo_lders
moles74747923mo__le_s
molter84119423molt_er_
momsers113810843mo_msers
momzers20367133mo_mzers
moneyers1337423moneyers
mongers104217273mo_ngers
monikers1437413monikers
monomers12311033monomers
monsters103314553monsters
montero9310133mont_ero
monteros1039453mont_eros
montes84226933mont_e_s
moochers15369123moochers
mooleys1236863mo_oleys
mooners94015343mo_oners
moonless10278043moonless
moonlets10247473moonlets
mooter83921093moot_er_
mootness1036753mootness
mopers104220373mo__pers
moppers133412463mo_ppers
morales93619403morale_s
mortars93411523mort_ars
mortisers1186163mortisers
moshers124017843mo_shers
mossers94116193mo_ssers
motels83616893mo_t_els
motes75944003mo_t_e_s
motets84216193mo_t_ets
mother113718643mo_ther_
mothery153710513mo_thery
mothier121910213mothier_
motile83818343motile__
motioners1146573motioners
motives123611893motive_s
motley1139383mo_tle_y
motlier92010583motlier_
motorless1145723motorless
motors84616603mo_t_ors
motte75526973mott_e__
mottling11197753mottling
mottos84615243mott__os
motts76527003mott___s
moulders11348343moulders
moulter93812423moulter_
mounters103712503mounters
mourners1036913mourners
mousers95216443mo_users
mouther123812813mouther_
mouthless1444713mouthless
moveless1367753moveless
movers115117193mo__vers
mowers113219403mo__wers
muddlers12428813muddlers
mufflers16316003mufflers
mullers93217303m_ullers
mumblers14328763mumblers
murthers1336543murthers
musters94522513must_ers
mutter84418883mutt_er_
mutterers11247373mutterers
mutules9311843mutule_s
muzzlers18245203muzzlers
myrtles1235733myrtle_s
natters73718063natt_ers
nestlers8359223nestlers
netters73618583nett_ers
nettler7349503nettler_
nettles73214083nettle_s
nobblers12318563nobblers
northers1139333northers
notchers13279423notchers
noteless839403noteless
noters64021003no_t_ers
noticers1035693noticers
nutters74215433nutt_ers
oaters65029793_oat_ers
oglers74313183_o_glers
oilers64721193_o_ilers
omitters10277653omitters
ostler63312193_ostler_
others93918003_o_thers
ottars64112223_ott_ars
otter54423973_ott_er_
outers64230173_out_ers
outlets73616363_outlets
outliers82610673_outliers
oxters134813273_oxt_ers
patters94825193patt_ers
petters93722363pett_ers
pettles93916483pettle_s
plotters104011553plott_ers
poetless1038723poetless
polers84225643po__lers
pollers93420023po_llers
poolers94217423po_olers
porters93722703port_ers
portless10310643portless
posters93928013post_ers
pothers123818623po_thers
potteens10256793potteens
potter83926983pott_er_
potterers11218663potterers
pottery123011073pott_ery
pottier93516493pottier_
potties93723543pottie_s
pottle84416103pottle__
potzers184010543po_tzers
poulters103911053poulters
pouters94221873pout_ers
powters124015663powt_ers
prattlers11195323prattlers
putters94219193putt_ers
puttiers10288013puttiers
ratters74422473ratt_ers
rattler74012743rattler_
rattles73217303rattle_s
ritters74020623ritt_ers
rollers73117473ro_llers
rooters74522933root_ers
rootles73215633rootle_s
rootless83910443rootless
rootlets8308653rootlets
rosters73727543rost_ers
rotifers1136043rotifers
rotter64325463rott_er_
rottes64524833rott_e_s
routers74822873rout_ers
rustlers8339853rustlers
setters73822063sett_ers
settler73410653settler_
settles73916003settle_s
settlors8255013settlors
shuttlers1254123shuttlers
sitters74221553sitt_ers
slotters84012403slott_ers
smatters104011713smatt_ers
smoothers14206043smoothers
smothers13349933smo_thers
soothers113913433soothers
sorters74221133sort_ers
souters74422603sout_ers
southers114214453southers
spotters104313383spott_ers
stylers10359353_stylers
sutlers73116973_sutlers
swotters11448483swott_ers
talers64628143__talers
tatters74520483tatt_ers
tattler73112213tattler_
tattles73616283tattle_s
tetters74320473tett_ers
throttlers1352483throttlers
tilers63523503__tilers
titters74219623titt_ers
tittles73413253tittle_s
toddlers10346963toddlers
togglers10276953togglers
toilers74116263to_ilers
tollers73217463to_llers
toolers74416503to_olers
tooters73818773toot_ers
tootler73511123tootler_
tootles72915603tootle_s
toters65026363to_t_ers
totter65021463tott_er_
totterers9186813totterers
tottery10388483tott_ery
touters74018353tout_ers
trotters83310243trott_ers
turtlers8258203turtlers
utters63817123_utt_ers
vetters104016323vett_ers
vittles103211113vittle_s
voteless1137493voteless
voters95017443vo_t_ers
wattles103814073wattle_s
wattless11268723wattless
wetters103817753wett_ers
whittlers1594333whittlers
wobblers15327883wobblers
woolers104214023wo_olers
yatters103914623yatt_ers
yodelers1235673yodelers
yodlers11298923yo_dlers
yowlers13328923yo_wlers
zosters163015413zost_ers

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 Limit1461623956.93621073.0
3Display Results3953950.1562532.1
 (SQL Overall)1786913957.24824653.8
 
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.