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

260 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
fathered15151043(None) 
feathered16188891feathered
gathered13149381gathered
lathered121512331lathered
adhered1239232_adhered
battered113315072battered
blathered15168362blathered
bothered142110392bothered
catered103117782cat_ered
dithered13189292dithered
faltered122811002faltered
fathead1437862fathe_ad
fatheaded1744272fatheaded
father125116712father__
fatherly1745072fatherly
fathers133916502father_s
fathomed1744732fathomed
fattened12268282fattened
featherbed19174662featherbed
fettered12259492fettered
flattered13188642flattered
furthered1644482furthered
gatherer12147912gatherer
heathered16149462heathered
kashered1636402kashered
latherer111310452latherer
leathered13148712leathered
mattered112412912mattered
mothered142310102mothered
nattered92011632nattered
pattered112714212pattered
pothered142311042pothered
slathered13148552slathered
tattered92011452tattered
tethered1238492tethered
unfathered1743782unfathered
watered113014962wat_ered
weathered16168512weathered
withered15169432withered
wuthered15157432wuthered
yattered12239542yattered
adhere10310333_adhere_
adherend1343863_adherend
adherer1137573_adherer
adheres11310163_adheres
altered83215753_altered
angered93013473_angered
anthemed1446953anthemed
antherid12611093antherid
antlered938263antlered
ashlered1244623_ashlered
attired8238913_attired
authored1238263authored
badgered1336213badgered
bannered11299323bannered
bantered113313653bantered
barbered13259553barbered
bartered113113033bartered
bathed125518743bath__ed
bather115322513bather__
bathers124720363bather_s
battened11259573battened
batterer102713223batterer
bettered113011843bettered
bittered112711833bittered
blatherer14176723blatherer
blattered12198583blattered
blethered15165433blethered
blithered15156123blithered
brothered1546003brothered
butchered1744583butchered
buttered112712633buttered
cacheted16148243cacheted
cambered15129003cambered
cancered132411553cancered
cankered153010223cankered
cantered113415993cantered
capered123014043ca_pered
careered1139503careered
cashiered1543403cashiered
caterer92815953cat_erer
cathead1338753cathe_ad
cathected1744543cathected
catheter1338153catheter
cathexes2036273cathexes
chattered15198003chattered
ciphered1637053ciphered
clattered12178423clattered
cohered133514693_cohered
coshered14610293coshered
cottered112511743cottered
cratered1149693crat_ered
cyphered1934653cyphered
dackered16116893dackered
daggered12246403daggered
daikered1495223daikered
dandered112110963dandered
dangered11248513dangered
ditherer12187763ditherer
entered82718883ent_ered
faceted13509573fa_ceted
factored1436233factored
faired105915773fa__ired
faithed1437163faith__ed
falterer11239873falterer
fared95842343fa___red
farther1348343farther__
fashed136720253fash__ed
fastened12257853fastened
fatbird1344033fatbir_d
fated95632133fat___ed
fatheads1536763fatheads
fatherhood2053293fatherhood
fathering161010093fathering
fatherland1753003fatherland
fatherless1644213fatherless
fathomer1645293fathomer
fatigued1342943fatigued
fatted105419843fat__ted
fattener11268113fattener
fatter94523213fatter__
favored1455983fa_vored
favoured1533963favoured
feather133613503feather__
featherbeds20193573featherbeds
featheredge1972713featheredge
featherhead2153073featherhead
featherier1645803featherier
feathers143513243feather_s
feathery17368073feather_y
featured1237683feat_ured
fendered13258673fendered
festered122512113festered
fetterer11207813fetterer
fevered14339723f_evered
fibered1337643f_ibered
filtered12259043filtered
fingered13128333fingered
flathead1535813flathe_ad
flattened13185303flattened
flatterer12187683flatterer
fleered11309503f_leered
flittered13196253flittered
flowered1546013flowered
fluttered13185943fluttered
foddered1434553foddered
forgathered1951823forgathered
fostered122210453fostered
frittered13205163frittered
fullered1236383fullered
furtherer1543813furtherer
gandered112211173gandered
garnered10247123garnered
gartered10319603gartered
gather104115863gather__
gatherers13156893gatherers
gathers114315073gather_s
gettered10258613gettered
goatherd1335263goather_d
godfathered2051413godfathered
guttered10259173guttered
hachured1744393hachured
haltered123112573haltered
hammered16218853hammered
hampered16239933hampered
hankered16289443hankered
hatcheled1844223hatcheled
hatred104814333hat__red
havered144011453ha_vered
ingathered1542963ingathered
inhered11313163_inhered
jabbered2034433jabbered
jittered16267223jittered
koshered1636063koshered
laagered1055853laagered
lackered15108683lackered
laddered1136743laddered
lagered92311153la_gered
lappered13288213lappered
latened8711923lat_ened
laterad8310853lat_erad
lathed104718463lath__ed
lather95124363lather__
latherers12158853latherers
lathers104321883lather_s
lathery133911123lather_y
laveered1235253laveered
lawyered1534033lawyered
layered11259413la_yered
lechered1437523lechered
lettered92910783lettered
littered92511383littered
mammered12237653mammered
mannered11249653mannered
mastered112614013mastered
matured10310043mat_ured
metered103514013met_ered
mitered103213233mit_ered
murthered1544483murthered
muttered112610803muttered
natured838963nat_ured
neatherd12107193neather_d
ochered132610283_ochered
paltered113012503paltered
pampered15229233pampered
pandered121812573pandered
papered122513173pa_pered
partnered1244493partnered
pattened11299393pattened
patterer103112183patterer
patterned1265753patterned
paupered13216943paupered
petered103314973pet_ered
pottered112311663pottered
puttered112611153puttered
racheted14149513racheted
raftered1237673raftered
rapiered1136053rapiered
ratcheted1554783ratcheted
rather94319743rather__
rattened9218623rattened
regathered15124573regathered
sabered103213023sa_bered
sacheted14127843sacheted
saggered11237553saggered
satcheled1544423satcheled
scattered12197363scattered
shattered13178213shattered
slithered13136623slithered
smattered12186793smattered
smothered1545683smothered
spattered12187653spattered
sphered133512313_sphered
steered83615253_steered
swithered16135463swithered
syphered1755013syphered
tabered103311593ta_bered
tampered13279463tampered
tapered102612933ta_pered
themed125912583__themed
there87527393__there_
theres96525473__theres
tiered73613973__tiered
tittered9239493tittered
tochered1437913tochered
tottered9208703tottered
upgathered1742023upgathered
ushered1139153_ushered
uttered82712443_uttered
wafered14288433wa_fered
wagered12299333wa_gered
waitered1238763waitered
wandered132110793wandered
waterbed1436453wat_erbed
waterer103314083wat_erer
wavered142910433wa_vered
witherer14187953witherer
witherod15156153witherod
yabbered1633963yabbered
yammered16225763yammered

Search took 10 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.423422437.4
2DLD Change Limit1461622608.62316950.2
3Display Results2602600.2361101.7
 (SQL Overall)1786912609.28219251.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.