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) 
bettered113011831bettered
fettered12259491fettered
guttered10259151guttered
lettered92910781lettered
battered113315052battered
bittered112711832bittered
buttered112712622buttered
centered112513522centered
cottered112511732cottered
entered82718882_entered
festered122512102festered
fetterer11207812fetterer
gartered10319582gartered
gathered13149372gathered
gendered11258872gendered
gestured1036992gestured
getter74117612getter__
getters84216092getter_s
glittered11195402glittered
jittered16267222jittered
letterer8259222letterer
littered92511382littered
mattered112412902mattered
metered103514012me_tered
muttered112610792muttered
nattered92011622nattered
neutered937422neutered
pattered112714202pattered
peltered112510442peltered
pestered112814952pestered
petered103314962pe_tered
pottered112311662pottered
puttered112611142puttered
reuttered1036072reuttered
tattered92011442tattered
teetered9258302teetered
tentered96412102tentered
tethered1238492tethered
tittered9239492tittered
tottered9208702tottered
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
enfettered1442483enfettered
enterer72015633_enterer
faltered122810983faltered
fathered151510433fathered
fattened12268283fattened
feathered16188893feathered
featured1237683featured
fendered13258673fendered
fetted104817893fett__ed
fetter94120383fetter__
fetterers12267043fetterers
fetters103517903fetter_s
fettled11378933fett_led
fevered14339723fe_vered
filtered12259043filtered
flattered13188623flattered
flittered13196253flittered
fluttered13185943fluttered
fostered122210443fostered
frittered13205163frittered
gandered112211173gandered
garnered10247113garnered
gatherer12147903gatherer
geared85317743ge__ared
geeked124510163ge__eked
genteel836753gente_el
gentled9389093gent_led
gestated102910573gestated
gesture839243gesture_
gesturer935983gesturer
gestures9310013gestures
gettering112310033gettering
ghettoed1342083ghett_oed
gibbered1444303gibbered
gingered11127743gingered
gitted84015053gitt__ed
gittern8337503gitter_n
gitterns9326563gitterns
glistered11176293glistered
glowered1345753glowered
goateed9307063goate_ed
goffered1634523goffered
greatened1144583greatened
guttated10266873guttated
gutted84716363gutt__ed
gutter73817703gutter__
gutters83715503gutter_s
guttery11427753gutter_y
guttled9378993gutt_led
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
peppered1236123peppered
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
unfettered1443653unfettered
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 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.1731032896.0
2DLD Change Limit1461622478.21617789.9
3Display Results2472470.1102245.5
 (SQL Overall)1786912478.49921024.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.