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

247 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
gettered1025861(None) 
bettered113011841bettered
fettered12259491fettered
guttered10259171guttered
lettered92910781lettered
battered113315072battered
bittered112711832bittered
buttered112712632buttered
centered112513522centered
cottered112511742cottered
entered82718882_entered
festered122512112festered
fetterer11207812fetterer
gartered10319602gartered
gathered13149382gathered
gendered11258872gendered
gestured1036992gestured
getter74117612getter__
getters84216102getter_s
glittered11195412glittered
jittered16267222jittered
letterer8259222letterer
littered92511382littered
mattered112412912mattered
metered103514012me_tered
muttered112610802muttered
nattered92011632nattered
neutered937422neutered
pattered112714212pattered
peltered112510452peltered
pestered112814972pestered
petered103314972pe_tered
pottered112311662pottered
puttered112611152puttered
reuttered1036072reuttered
tattered92011452tattered
teetered9258302teetered
tentered96412102tentered
tethered1238492tethered
tittered9239492tittered
tottered9208702tottered
uttered82712442_uttered
weltered12238442weltered
westered122511872westered
yattered12239542yattered
altered83215753_altered
antlered938263antlered
attired8238913_attired
bantered113313653bantered
bartered113113033bartered
battened11259573battened
batterer102713223batterer
beavered1437503beavered
betattered1343143betattered
betted94721163bett__ed
better84723703better__
betters94422093better_s
bistered112913333bistered
bitterer10309783bitterer
blattered12198583blattered
blethered15165433blethered
bothered142110393bothered
cantered113415993cantered
catered103117783_catered
centred103411683cent_red
chattered15198003chattered
chittered15166413chittered
clattered12178423clattered
cluttered12185943cluttered
cratered1149693cratered
deterged11127923de_terged
deterred10137803deterred
detoured1036513detoured
dewatered1444743dewatered
dithered13189293dithered
dotterel945063dotterel
enfettered1442483enfettered
enterer72015633_enterer
faltered122811003faltered
fathered151510433fathered
fattened12268283fattened
feathered16188893feathered
featured1237683featured
fendered13258673fendered
fetted104817893fett__ed
fetter94120383fetter__
fetterers12267043fetterers
fetters103517903fetter_s
fettled11378933fett_led
fevered14339723fe_vered
filtered12259043filtered
flattered13188643flattered
flittered13196253flittered
fluttered13185943fluttered
fostered122210453fostered
frittered13205163frittered
gandered112211173gandered
garnered10247123garnered
gatherer12147913gatherer
geared85317743ge__ared
geeked124510163ge__eked
genteel836753gente_el
gentled9389093gent_led
gestated102910573gestated
gesture839243gesture_
gesturer935983gesturer
gestures9310013gestures
gettering112310033gettering
ghettoed1342083ghett_oed
gibbered1444303gibbered
gingered11127743gingered
gitted84015053gitt__ed
gittern8337503gitter_n
gitterns9326573gitterns
glistered11176303glistered
glowered1345753glowered
goateed9307063goate_ed
goffered1634523goffered
greatened1144583greatened
guttated10266873guttated
gutted84716363gutt__ed
gutter73817713gutter__
gutters83715513gutter_s
guttery11427763gutter_y
guttled9378993gutt_led
haltered123112573haltered
heathered16149463heathered
hectored1436893hectored
jeered143912793je__ered
jetted143915083jett__ed
jettied15366973jett_ied
kittened1334523kittened
lathered121512333lathered
leathered13148713leathered
lechered1437523lechered
lectured11127233lectured
leered73816223le__ered
leistered1037043leistered
letted74118543lett__ed
letter63722583letter__
letterers9228113letterers
letterhead1442363letterhead
lettermen1164283lettermen
letters73819853letter_s
levered114212303le_vered
litterer82810173litterer
loitered938183loitered
lustered92510613lustered
mastered112614013mastered
membered1535903membered
mentored1138003mentored
metred95315143me_t_red
mettled103510543mett_led
mitered103213233_mitered
mittened1136363mittened
mothered142310103mothered
mustered112511513mustered
mutterer10218913mutterer
neatened937043neatened
netted74118713nett__ed
netter63722023netter__
netters73618583netter_s
nettled8339943nett_led
oystered1236923oystered
paltered113012503paltered
pattened11299393pattened
patterer103112183patterer
patterned1265753patterned
peered93819493pe__ered
peppered1236133peppered
pesterer102412713pesterer
petted94121523pett__ed
petter83924773petter__
petters93722363petter_s
pettled103611513pett_led
pewterer13256313pewterer
portered112311553portered
pothered142311043pothered
potterer102310263potterer
putterer10209913putterer
raftered1237673raftered
rattened9218623rattened
realtered1037903realtered
reentered1038573reentered
relettered1144333relettered
rendered102512263rendered
restored96417193restored
retired84620143re_tired
retted74826313rett__ed
revered112819333re_vered
scattered12197363scattered
sceptered1444723sceptered
scuttered12166423scuttered
sectored1138083sectored
settee63721023sette_e_
settees73513633sette_es
setter64023723setter__
setters73822063setter_s
settled83210873sett_led
severed113513863se_vered
sewered112911243se_wered
shattered13178213shattered
sheltered1335583sheltered
shuttered13156333shuttered
sintered92213903sintered
sistered92612803sistered
skeltered1443873skeltered
skittered1434633skittered
smattered12186793smattered
spattered12187653spattered
sputtered12166323sputtered
steered83615253_steered
stuttered10145763stuttered
sweltered1344453sweltered
teddered11255183teddered
telfered1234883telfered
tempered13248223tempered
tendered102510603tendered
tetter64322453tetter__
tetters74320473tetter_s
textured1695483textured
tiered73613973__tiered
titterer8268523titterer
totterer8217793totterer
twittered1333813twittered
unentered1037573unentered
unfettered1443653unfettered
unlettered1143953unlettered
unuttered1065733unuttered
utterer71910463_utterer
vectored1435643vectored
veered103612743ve__ered
veneered1235983veneered
ventured1238273ventured
vestured1237463vestured
vetted104316323vett__ed
vetter93417643vetter__
vetters104016323vetter_s
waitered1238763waitered
watered113014963_watered
weathered16168513weathered
wetted103717023wett__ed
wetter93919443wetter__
wetters103817753wetter_s
wintered122111573wintered
withered15169433withered
wuthered15157433wuthered

Search took 8 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 Limit1461622476.92321112.5
3Display Results2472470.0932655.9
 (SQL Overall)1786912477.43924020.8
 
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.