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

261 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
fettered1225949(None) 
bettered113011831bettered
festered122512101festered
fetterer11207811fetterer
gettered10258611gettered
lettered92910781lettered
battered113315052battered
bittered112711832bittered
buttered112712622buttered
centered112513522centered
cottered112511732cottered
enfettered1442482enfettered
entered82718882_entered
faltered122810982faltered
fathered151510432fathered
fattened12268282fattened
feathered16188892feathered
featured1237682featured
fendered13258672fendered
fetted104817892fett__ed
fetter94120382fetter__
fetterers12267042fetterers
fetters103517902fetter_s
fettled11378932fett_led
fevered14339722fe_vered
filtered12259042filtered
flattered13188622flattered
flittered13196252flittered
fluttered13185942fluttered
fostered122210442fostered
frittered13205162frittered
guttered10259152guttered
jittered16267222jittered
letterer8259222letterer
littered92511382littered
mattered112412902mattered
metered103514012me_tered
muttered112610792muttered
nattered92011622nattered
neutered937422neutered
pattered112714202pattered
peltered112510442peltered
pestered112814952pestered
petered103314962pe_tered
pottered112311662pottered
puttered112611142puttered
reuttered1036072reuttered
tattered92011442tattered
teetered9258302teetered
tentered96412102tentered
tethered1238492tethered
tittered9239492tittered
tottered9208702tottered
unfettered1443652unfettered
uttered82712432_uttered
weltered12238432weltered
westered122511862westered
yattered12239532yattered
altered83215733_altered
antlered938253antlered
attired8238913_attired
bantered113313633bantered
bartered113113013bartered
battened11259573battened
batterer102713213batterer
beavered1437503beavered
betattered1343143betattered
betted94721163bett__ed
better84723703better__
betters94422093better_s
bistered112913323bistered
bitterer10309773bitterer
blattered12198563blattered
blethered15165433blethered
bothered142110393bothered
cantered113415983cantered
catered103117763_catered
centred103411683cent_red
chattered15197983chattered
chittered15166413chittered
clattered12178403clattered
cluttered12185933cluttered
cratered1149673cratered
deterged11127923de_terged
deterred10137803deterred
detoured1036513detoured
dewatered1444743dewatered
dithered13189293dithered
dotterel945063dotterel
enterer72015633_enterer
factored1436213factored
falterer11239853falterer
fastened12257853fastened
fatted105419843fatt__ed
fattener11268113fattener
fatter94523213fatter__
feared106320433fe__ared
feater95224053feater__
featherbed19174663featherbed
feature1039853feature_
features11310333features
fedexed1934073fe_dexed
feezed19439993fe__ezed
felted103714653felt__ed
ferreled1234833ferreled
ferreted1236323ferreted
fester94723513fester__
festers104121393fester_s
fetched163710473fe_tched
feted94420933fe_t__ed
fettering132310513fettering
fettle93713123fett_le_
fettles103912733fett_les
fibered1337643f_ibered
filterer11258143filterer
fingered13128323fingered
fitted104716663fitt__ed
fitter94120033fitter__
fitters104517743fitter_s
flattened13185303flattened
flatterer12187673flatterer
fleered11309503f_leered
flowered1546013flowered
flustered13185883flustered
flutterer12185263flutterer
foddered1434553foddered
fosterer11239513fosterer
fretted113411853frett__ed
fretter103412753fretter__
fretters113410303fretter_s
fritterer12234403fritterer
fullered1236383fullered
furthered1644473furthered
gartered10319583gartered
gathered13149373gathered
gendered11258873gendered
gestured1036993gestured
getter74117613getter__
getters84216093getter_s
glittered11195403glittered
haltered123112553haltered
heathered16149463heathered
hectored1436873hectored
jeered143912793je__ered
jetted143915083jett__ed
jettied15366973jett_ied
kittened1334523kittened
lathered121512323lathered
leathered13148713leathered
lechered1437523lechered
lectured11127223lectured
leered73816223le__ered
leistered1037043leistered
letted74118543lett__ed
letter63722583letter__
letterers9228113letterers
letterhead1442353letterhead
lettermen1164283lettermen
letters73819853letter_s
levered114212303le_vered
litterer82810173litterer
loitered938183loitered
lustered92510603lustered
mastered112614003mastered
membered1535903membered
mentored1138003mentored
metred95315143me_t_red
mettled103510543mett_led
mitered103213233_mitered
mittened1136363mittened
mothered142310103mothered
mustered112511503mustered
mutterer10218913mutterer
neatened937043neatened
netted74118713nett__ed
netter63722023netter__
netters73618583netter_s
nettled8339943nett_led
oystered1236913oystered
paltered113012483paltered
pattened11299393pattened
patterer103112173patterer
patterned1265743patterned
peered93819483pe__ered
peppered1236113peppered
pesterer102412703pesterer
petted94121523pett__ed
petter83924773petter__
petters93722363petter_s
pettled103611503pett_led
pewterer13256313pewterer
portered112311533portered
pothered142311043pothered
potterer102310263potterer
putterer10209913putterer
raftered1237663raftered
rattened9218623rattened
realtered1037893realtered
reentered1038573reentered
relettered1144333relettered
rendered102512263rendered
restored96417193restored
retired84620143re_tired
retted74826313rett__ed
revered112819333re_vered
scattered12197353scattered
sceptered1444723sceptered
scuttered12166423scuttered
sectored1138063sectored
settee63721023sette_e_
settees73513633sette_es
setter64023723setter__
setters73822063setter_s
settled83210873sett_led
severed113513863se_vered
sewered112911243se_wered
shattered13178203shattered
sheltered1335573sheltered
shuttered13156333shuttered
sintered92213903sintered
sistered92612803sistered
skeltered1443873skeltered
skittered1434633skittered
smattered12186783smattered
spattered12187643spattered
sputtered12166323sputtered
steered83615253_steered
stuttered10145763stuttered
sweltered1344453sweltered
teddered11255183teddered
telfered1234883telfered
tempered13248213tempered
tendered102510603tendered
tetter64322453tetter__
tetters74320473tetter_s
textured1695483textured
tiered73613973__tiered
titterer8268523titterer
totterer8217793totterer
twittered1333813twittered
unentered1037573unentered
unlettered1143953unlettered
unuttered1065733unuttered
utterer71910463_utterer
vectored1435623vectored
veered103612743ve__ered
veneered1235983veneered
ventured1238273ventured
vestured1237463vestured
vetted104316323vett__ed
vetter93417643vetter__
vetters104016313vetter_s
waitered1238753waitered
watered113014953_watered
weathered16168513weathered
wetted103717023wett__ed
wetter93919443wetter__
wetters103817753wetter_s
wintered122111573wintered
withered15169433withered
wuthered15157433wuthered

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.1531167915.0
2DLD Change Limit1461622619.25015801.3
3Display Results2612610.1102372.7
 (SQL Overall)1786912619.51318783.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.