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

278 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
tottered920870(None) 
cottered112511731cottered
pottered112311661pottered
tattered92011441tattered
tittered9239491tittered
totterer8217791totterer
battered113315052battered
bettered113011832bettered
bittered112711832bittered
bothered142110392bothered
buttered112712622buttered
dotterel945062dotterel
fettered12259492fettered
fostered122210452fostered
gettered10258612gettered
guttered10259162guttered
jittered16267222jittered
lettered92910782lettered
littered92511382littered
loitered938182loitered
mattered112412902mattered
mothered142310102mothered
muttered112610792muttered
nattered92011622nattered
pattered112714202pattered
portered112311542portered
pothered142311042pothered
potterer102310262potterer
puttered112611142puttered
stuttered10145762stuttered
teetered9258302teetered
tentered96412102tentered
tethered1238492tethered
titterer8268522titterer
tochered1437912tochered
tortured935842tortured
totted74319952tott__ed
totter65021462totter__
totterers9186812totterers
totters74618732totter_s
tottery10388482totter_y
towered112911402to_wered
twittered1333812twittered
uttered82712432_uttered
yattered12239532yattered
altered83215733_altered
antlered938263antlered
attired8238913_attired
bantered113313633bantered
bartered113113013bartered
battened11259573battened
batterer102713213batterer
betattered1343143betattered
bistered112913323bistered
bitterer10309773bitterer
blattered12198563blattered
bolstered1246093bolstered
bordered1248933bordered
bottled104611233bott_led
bottomed1344673bottomed
bowered133113043bo_wered
brothered1546003brothered
cantered113415983cantered
catered103117773_catered
centered112513523centered
chattered15197993chattered
chittered15166413chittered
clattered12178403clattered
cluttered12185943cluttered
cockered17710213cockered
coffered1737673coffered
cohered133514693co_hered
compered153414923compered
coopered133310933coopered
coppered153410543coppered
cornered11311133cornered
coshered14610293coshered
cotter84926673cotter__
cotters94323443cotter_s
cottoned1138033cottoned
countered12313003countered
covered133315293co_vered
cowered133214653co_wered
cratered1149683cratered
dithered13189293dithered
doctored1245613doctored
doddered1234943doddered
donnered10307753donnered
dormered1255673dormered
dotted84717523dott__ed
dotter74419343dotter__
dotterels1043903dotterels
dotters83715973dotter_s
dottrel834463dott_rel
dowered122811553do_wered
entered82718883_entered
faltered122810983faltered
fathered151510433fathered
fattened12268283fattened
festered122512103festered
fetterer11207813fetterer
filtered12259043filtered
flattered13188623flattered
flittered13196253flittered
fluttered13185943fluttered
foddered1434553foddered
fosterer11239523fosterer
frittered13205163frittered
gartered10319583gartered
gathered13149373gathered
glittered11195403glittered
goateed9307063goate_ed
goffered1634523goffered
haltered123112553haltered
hollered1237603hollered
holstered1345883holstered
homered133212713ho_mered
hoovered15195413hoovered
hosteled1237283hosteled
hotted104319943hott__ed
hotter94720083hotter__
hovered143411573ho_vered
jotted143615173jott__ed
jotter134315633jotter__
jotters143413803jotter_s
kittened1334523kittened
koshered1636063koshered
lathered121512323lathered
letterer8259223letterer
litterer82810173litterer
lobstered1244643lobstered
loiterer837083loiterer
loppered13326753loppered
lotted74222403lott__ed
lotter64025603lotter__
lotteries9311073lotteries
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
paltered113012483paltered
pattened11299393pattened
patterer103112173patterer
patterned1265743patterned
peltered112510453peltered
pestered112814963pestered
petered103314973_petered
pondered126411293pondered
postured1139493postured
potted94624013pott__ed
potteen9319673potte_en
potter83926983potter__
potterers11218663potterers
potteries11313593potteries
potters94024343potter_s
pottery123011073potter_y
powdered15256893powdered
powered132911643po_wered
putterer10209913putterer
raftered1237663raftered
rattened9218623rattened
reuttered1036073reuttered
rogered939553ro_gered
roistered1037643roistered
rotted74524433rott__ed
rottener8216973rottener
rotter64325463rotter__
rotters74421393rotter_s
roystered1344873roystered
scattered12197353scattered
scuttered12166423scuttered
shattered13178203shattered
shuttered13156333shuttered
sintered92213903sintered
sistered92612803sistered
skittered1434633skittered
smattered12186783smattered
smothered1545683smothered
sobered102912433so_bered
softened1235663softened
soldered1038153soldered
sotted74121403sott__ed
spattered12187643spattered
sputtered12166323sputtered
steered83615253_steered
stoppered1444473stoppered
stotted83511423stott__ed
stoutened1053573stoutened
stutterer9164913stutterer
tabered103311593t_abered
tampered13279463tampered
tapered102612933t_apered
tatted74920533tatt__ed
tatter64024573tatter__
tatters74520483tatter_s
tattled84311483tatt_led
tattooed944573tattooed
tautened935423tautened
teddered11255183teddered
telfered1234883telfered
tempered13248223tempered
tendered102510603tendered
tetter64322453tetter__
tetters74320473tetter_s
textured1695483textured
tiered73613973__tiered
tillered937443tillered
timbered13137383timbered
tinkered1387683tinkered
titter63421163titter__
titterers9236993titterers
titters74219623titter_s
tittuped1142063tittuped
toileted936993toileted
toited74016753toit__ed
tokened1236393to_kened
tonsured976383tonsured
tooted74620123toot__ed
tooter64420803tooter__
tooters73818773tooter_s
toothed113310243toot_hed
tootled83511043toot_led
torture738593torture_
torturer835493torturer
tortures838913tortures
totaled839693to_taled
totalled935843totalled
toted64929483to_t__ed
toter55932133to_ter__
toters65026363to_ter_s
tother94117143tother__
tottering10229613tottering
toured74216153to__ured
touted74419743tout__ed
touter63821033touter__
touters74018353touter_s
toweled112410223to_weled
trotted83711283trott__ed
trotter73312253trotter__
trotters83310243trotter_s
tuckered1535963tuckered
tutored837553t_utored
tutoyered1341923tutoyered
tutted75117443tutt__ed
twitterer1243303twitterer
unuttered1065733unuttered
utterer71910463_utterer
waitered1238753waitered
watered113014953_watered
weltered12238433weltered
westered122511863westered
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.453394461.4
2DLD Change Limit1461622787.83018666.9
3Display Results2782780.1232260.2
 (SQL Overall)1786912788.40621257.6
 
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.