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

352 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
cottered11251174(None) 
pottered112311661pottered
tottered9208701tottered
battered113315052battered
bettered113011842bettered
bittered112711832bittered
bothered142110392bothered
buttered112712622buttered
cantered113415982cantered
catered103117772c_atered
centered112513522centered
chattered15197992chattered
chittered15166412chittered
clattered12178412clattered
cluttered12185942cluttered
cockered17710212cockered
coffered1737672coffered
cohered133514692co_hered
compered153414922compered
coopered133310942coopered
coppered153410542coppered
cornered11311132cornered
coshered14610292coshered
cotter84926672cotter__
cotters94323452cotter_s
cottoned1138032cottoned
countered12313002countered
covered133315292co_vered
cowered133214652co_wered
cratered1149682cratered
dotterel945062dotterel
fettered12259492fettered
fostered122210452fostered
gettered10258612gettered
guttered10259162guttered
jittered16267222jittered
lettered92910782lettered
littered92511382littered
loitered938182loitered
mattered112412902mattered
mothered142310102mothered
muttered112610792muttered
nattered92011622nattered
pattered112714202pattered
portered112311542portered
pothered142311042pothered
potterer102310262potterer
puttered112611142puttered
scattered12197352scattered
scuttered12166422scuttered
tattered92011442tattered
tittered9239492tittered
totterer8217792totterer
uttered82712432_uttered
yattered12239532yattered
accoutered1542783accoutered
altered83215743_altered
antlered938263antlered
attired8238913_attired
bantered113313633bantered
bartered113113013bartered
battened11259573battened
batterer102713213batterer
bistered112913333bistered
bitterer10309773bitterer
blattered12198573blattered
bolstered1246093bolstered
bordered1248933bordered
bottled104611233bott_led
bottomed1344673bottomed
bowered133113043bo_wered
brothered1546003brothered
cambered15129003cambered
cancered132411553cancered
cankered153010223cankered
capered123014043c_apered
captured1336573captured
careered1139493careered
caterer92815943c_aterer
catted95422473catt__ed
catteries11815533catteries
cattery123811603catter_y
centred103411683cent_red
cered85227443c___ered
chaptered17176793chaptered
chartered15158393chartered
chatterer14196843chatterer
cheered133713293c_heered
choppered1964883choppered
chowdered1944013chowdered
chuntered1536663chuntered
cindered1239793cindered
ciphered1637053ciphered
cittern9339143citter_n
citterns10318123citterns
clatterer11186993clatterer
clavered14187633clavered
clobbered16164103clobbered
cloistered1344523cloistered
clotted104011823clott__ed
clotured11246163clotured
clovered14187363clovered
clustered12186613clustered
coated94927043coat__ed
coatee84327223coate_e_
coatees93816553coate_es
coater84329573coater__
coaters93525793coater_s
coattend1134653coatte_nd
coattended1443103coattended
coattested1342983coattested
cockerel16107113cockerel
cockeyed2096123cockeyed
coerced1238583co__erced
coexerted1944763coexerted
cohere112716993co_here_
coherer122912783co_herer
coheres122917693co_heres
coinhered1536593coinhered
cointerred1346563cointerred
collared113211143collared
colleted113011663colleted
colored10313473co_lored
coloured1148313coloured
colter84625093colter__
colters93522443colter_s
commerced18125463commerced
compared153811823compared
compeered1646303compeered
compere134616623compere_
comperes143217973comperes
competed154113593competed
conceded1438293conceded
concerned1438643concerned
concerted14312113concerted
conferee13613733conferee
conferred1537753conferred
congeed113212313conge_ed
conjured18117903conjured
conquered2145463conquered
conserved1538853conserved
contemned1446793contemned
contend103511893conte_nd
contended1339273contended
contented12313043contented
contested12310703contested
contorted1239483contorted
contoured1237303contoured
contused1138443contused
convened143412223convened
converged1636973converged
conversed1538683conversed
converted15311563converted
conveyed17247923conveyed
cooeed95917863co_oe_ed
cooeyed1346893co_oeyed
cooter85128613cooter__
cooters94525733cooter_s
copter109822013copter__
copters113621283copter_s
corbeled1338373corbeled
cored85044223co___red
corseted11311473corseted
cortege1098953cortege_
corteges1198823corteges
cortexes1797613cortexes
cosseted1178343cosseted
costard104113353costar_d
costarred1244703costarred
costed95623123cost__ed
coster84331293coster__
costers94128343coster_s
costrel9310373cost_rel
costumed1365033costumed
coted85033853co_t__ed
coterie9417403co_terie
coteries10422713co_teries
cottae84615703cott_ae_
cottage104210573cottage_
cottager11306813cottager
cottages113310493cottages
cottagey14305233cottagey
cottar84613813cottar__
cottars94412243cottar_s
cotterless1244033cotterless
cottier93814173cott_ier
cottiers10399163cottier_s
couter84930223couter__
couters93827303couter_s
couture9310623couture_
coutures10311993coutures
coverer123113523co_verer
coveted133011523co_veted
cowherd1636953cowher_d
cozened19349183co_zened
cultured1137233cultured
cumbered15157963cumbered
cutter84521003cutter__
cutters94218963cutter_s
cuttled10319933cutt_led
cyphered1934653cyphered
dithered13189293dithered
doctored1245623doctored
doddered1234943doddered
donnered10307753donnered
dormered1255673dormered
dotted84717523dott__ed
dotter74419343dotter__
dotterels1043903dotterels
dotters83715973dotter_s
dottrel834463dott_rel
dowered122811553do_wered
entered82718883_entered
faltered122810993faltered
fathered151510433fathered
fattened12268283fattened
festered122512113festered
fetterer11207813fetterer
filtered12259043filtered
flattered13188633flattered
flittered13196253flittered
fluttered13185943fluttered
foddered1434553foddered
fosterer11239523fosterer
frittered13205163frittered
gartered10319593gartered
gathered13149383gathered
glittered11195413glittered
goateed9307063goate_ed
goffered1634523goffered
haltered123112563haltered
hollered1237603hollered
holstered1345883holstered
homered133212713ho_mered
hoovered15195413hoovered
hosteled1237293hosteled
hotted104319943hott__ed
hotter94720083hotter__
hovered143411573ho_vered
jotted143615173jott__ed
jotter134315633jotter__
jotters143413803jotter_s
kittened1334523kittened
koshered1636063koshered
lathered121512333lathered
letterer8259223letterer
litterer82810173litterer
lobstered1244643lobstered
loiterer837083loiterer
loppered13326753loppered
lotted74222403lott__ed
lotter64025603lotter__
lotteries9311083lotteries
lotters73921063lotter_s
lottery10389833lotter_y
louvered1244993louvered
lowered112711913lo_wered
lustered92510603lustered
mastered112614003mastered
metered103514013_metered
mitered103213233_mitered
mittened1136363mittened
moldered1237173moldered
mongered1238953mongered
mortared1137213mortared
motored1039933mo_tored
mottled10409973mott_led
mustered112511503mustered
mutterer10218913mutterer
neutered937423neutered
ochered132610283_ochered
offered1436143_offered
ordered9108533_ordered
osiered837123_osiered
otter54423973_otter__
otters64021513_otter_s
outbred10311263_outbred
overed102216623_o_vered
oystered1236923oystered
paltered113012493paltered
pattened11299393pattened
patterer103112173patterer
patterned1265743patterned
peltered112510453peltered
pestered112814973pestered
petered103314973_petered
pondered126411293pondered
postured1139493postured
potted94624013pott__ed
potteen9319673potte_en
potter83926983potter__
potterers11218663potterers
potteries11313603potteries
potters94024343potter_s
pottery123011073potter_y
powdered15256893powdered
powered132911643po_wered
putterer10209913putterer
raftered1237663raftered
rattened9218623rattened
reuttered1036073reuttered
rogered939553ro_gered
roistered1037653roistered
rotted74524433rott__ed
rottener8216973rottener
rotter64325463rotter__
rotters74421393rotter_s
roystered1344873roystered
scatterer11186293scatterer
sceptered1444723sceptered
scouthered1643643scouthered
scowdered1643743scowdered
shattered13178203shattered
shuttered13156333shuttered
sintered92213903sintered
sistered92612803sistered
skittered1434633skittered
smattered12186783smattered
smothered1545683smothered
sobered102912433so_bered
softened1235663softened
soldered1038153soldered
sotted74121403sott__ed
spattered12187643spattered
sputtered12166323sputtered
steered83615253_steered
stuttered10145763stuttered
teetered9258303teetered
tentered96412103tentered
tethered1238493tethered
tiered73613973__tiered
titterer8268523titterer
tochered1437913tochered
tortured935843tortured
totted74319953tott__ed
totter65021463totter__
totterers9186813totterers
totters74618733totter_s
tottery10388483totter_y
towered112911403to_wered
twittered1333813twittered
unuttered1065733unuttered
utterer71910463_utterer
waitered1238753waitered
watered113014953_watered
weltered12238433weltered
westered122511873westered
wintered122111573wintered
withered15169433withered
wondered13239943wondered
wotted104115713wott__ed
wuthered15157433wuthered

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.420425454.8
2DLD Change Limit1461623527.78318779.6
3Display Results3523520.1562256.4
 (SQL Overall)1786913528.35921377.1
 
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.