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

204 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
fetterer1120781(None) 
fettered12259491fettered
fetterers12267041fetterers
letterer8259221letterer
batterer102713212batterer
bettered113011842bettered
bitterer10309772bitterer
enterer72015632_enterer
falterer11239862falterer
fattener11268112fattener
festered122512112festered
fetter94120382fett__er
fetters103517902fetter_s
filterer11258142filterer
flatterer12187682flatterer
flutterer12185262flutterer
fosterer11239522fosterer
fritterer12234402fritterer
gettered10258612gettered
lettered92910782lettered
letterers9228112letterers
litterer82810172litterer
mutterer10218912mutterer
patterer103112172patterer
pesterer102412712pesterer
pewterer13256312pewterer
potterer102310262potterer
putterer10209912putterer
titterer8268522titterer
totterer8217792totterer
utterer71910462_utterer
alterer72714003_alterer
austerer838383austerer
banterer102811773banterer
barterer102711633barterer
battener10369393battener
battered113315053battered
batterers113110713batterers
better84723703bett__er
betters94422093better_s
bittered112711833bittered
buttered112712623buttered
butterier1177453butterier
caterer92815943_caterer
centered112513523centered
chatterer14196843chatterer
clatterer11186993clatterer
cottered112511733cottered
deterger10147593de_terger
deterrer9137013deterrer
dewaterer1343713dewaterer
ditherer12187763ditherer
dotterel945063dotterel
eagerer8248823_eagerer
enfettered1442483enfettered
entered82718883_entered
enterers82214153_enterers
faltered122810993faltered
falterers12238033falterers
fastener11227833fastener
fathered151510433fathered
fattened12268283fattened
fatteners12236873fatteners
fatter94523213fatt__er
fattier103513463fatt_ier
fearer94820183fe__arer
feater95224053feat__er
feather133613503feat_her
feathered16188893feathered
featherier1645803featherier
featlier1136453featlier
feature1039853feature_
featured1237683featured
features11310333features
feeder103513843fe__eder
feeler93215173fe__eler
fendered13258673fendered
ferreter1136543ferreter
fester94723513fest__er
festers104121393fester_s
fetcher153510393fe_tcher
fetted104817893fett__ed
fettering132310513fettering
fettle93713123fett_le_
fettled11378933fett_led
fettles103912733fett_les
fevered14339723fe_vered
filtered12259043filtered
filterers12206973filterers
fingerer12127223fingerer
fitter94120033fitt__er
fitters104517753fitter_s
flattener12175173flattener
flattered13188633flattered
flatterers13175913flatterers
flittered13196253flittered
flowerer1435453flowerer
fluttered13185943fluttered
flutterers13184593flutterers
fostered122210453fostered
fosterers12238023fosterers
fretter103412753frett__er
fretters113410303fretter_s
frettier1156593frett_ier
frittered13205163frittered
fritterers13203393fritterers
fruiterer1243333fruiterer
furtherer1543813furtherer
gatherer12147913gatherer
gesturer935983gesturer
getter74117613gett__er
getters84216103getter_s
guttered10259163guttered
jeerer13389933je__erer
jettier14358693jett_ier
jittered16267223jittered
jitterier1644433jitterier
latherer111310453latherer
lecturer10136033lecturer
letter63722583lett__er
lettermen1164283lettermen
letters73819853letter_s
littered92511383littered
litterers9228193litterers
loiterer837083loiterer
mattered112412903mattered
metered103514013me_tered
miterer92511333_miterer
muttered112610793muttered
mutterers11247373mutterers
nattered92011623nattered
netter63722023nett__er
netters73618583netter_s
nettier74211813nett_ier
nettler7349503nett_ler
nettlier864813nettlier
neutered937423neutered
oysterer1136103oysterer
palterer102411283palterer
pattered112714203pattered
patterers112410123patterers
peltered112510453peltered
pepperer1145283pepperer
pestered112814973pestered
pesterers112510463pesterers
petered103314973pe_tered
petter83924773pett__er
petters93722363petter_s
pettier94213613pett_ier
pewterers14216043pewterers
pottered112311663pottered
potterers11218663potterers
puttered112611143puttered
putterers11238363putterers
rattener8238533rattener
renderer9239743renderer
restorer84813723restorer
retirer74715013re_tirer
reuttered1036073reuttered
reverer103815833re_verer
rottener8216973rottener
scatterer11186293scatterer
settee63721023sette_e_
settees73513633sette_es
setter64023723sett__er
setters73822063setter_s
settler73410653sett_ler
severer103511563se_verer
shatterer12177203shatterer
shelterer1245033shelterer
smatterer11185813smatterer
sputterer11165263sputterer
steerer73113633_steerer
stutterer9164913stutterer
tattered92011443tattered
teetered9258303teetered
temperer12227723temperer
tenderer9228733tenderer
tentered96412103tentered
tethered1238493tethered
tetter64322453tett__er
tetters74320473tetter_s
tittered9239493tittered
titterers9236993titterers
tottered9208703tottered
totterers9186813totterers
twitterer1243303twitterer
unfettered1443653unfettered
uttered82712433_uttered
utterers8218653_utterers
veneerer1145033veneerer
venturer1137243venturer
verderer1245373verderer
vetter93417643vett__er
vetters104016323vetter_s
waterer103314073_waterer
weltered12238433weltered
westered122511873westered
westerner1244963westerner
wetter93919443wett__er
wetters103817753wetter_s
winterer112110443winterer
witherer14187953witherer
yattered12239533yattered

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 Limit1461622048.26617682.3
3Display Results2042040.0932193.5
 (SQL Overall)1786912048.81220278.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.