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

226 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
rattened921862(None) 
battened11259571battened
fattened12268281fattened
pattened11299391pattened
rattener8238531rattener
attend7258972_atten_d
attended1035762_attended
attuned835172_attuned
battener10369392battener
battered113315052battered
fastened12257852fastened
fattener11268112fattener
flattened13185302flattened
hastened12239102hastened
kittened1334522kittened
latened8711922la_tened
mattered112412902mattered
mittened1136362mittened
nattered92011622nattered
pattered112714202pattered
patterned1265742patterned
raftered1237662raftered
rationed9410092rationed
ratooned977102ratooned
ratted74923342ratt__ed
ratteen7329112ratte_en
ratteens8256052ratteens
ratten64217382ratten__
ratteners9237262ratteners
rattens74213402ratten_s
rattled84012952ratt_led
rattooned1043842rattooned
ravened115012282ra_vened
rottener8216972rottener
tattered92011442tattered
tautened935422tautened
yattered12239532yattered
aliened81011743_aliened
altered83215743_altered
anteed75616113_ante_ed
atoned75417543_a_toned
attained997353_attained
attendee946403_attendee
attender935913_attender
attends8257593_attends
attent62818323_atten_t
attested936293_attested
attired8238913_attired
attorned955363_attorned
attune637983_attune_
attunes737823_attunes
bantered113313633bantered
bartend1038753barten_d
bartended1344663bartended
bartered113113013bartered
batted95623653batt__ed
batten85217123batten__
batteners11238163batteners
battens95313263batten_s
batterer102713213batterer
battled104213123batt_led
bettered113011843bettered
bittered112711833bittered
blattered12198573blattered
bratticed1443283bratticed
brattled11196723bratt_led
brazened20134903bra_zened
buttered112712623buttered
buttoned1137503buttoned
caftaned1445093caftaned
cantered113415983cantered
cantoned111411523cantoned
careened1139193careened
cartoned111312833cartoned
catered103117773ca_tered
catted95422473catt__ed
chastened1545883chastened
chattered15197993chattered
clattered12178413clattered
coattend1134653coatten_d
coattended1443103coattended
cottered112511733cottered
cottoned1138033cottoned
cratered1149683cra_tered
cravened1476723cra_vened
dampened1435623dampened
darkened1435943darkened
davened124610073da_vened
dratted9358593dratt__ed
faltered122810993faltered
fastener11227833fastener
fathered151510433fathered
fatted105419843fatt__ed
fatten94314903fatten__
fatteners12236873fatteners
fattens105111713fatten_s
fettered12259493fettered
flattener12175173flattener
flattered13188633flattered
frittered13205163frittered
gardened1137003gardened
gartered10319593gartered
gathered13149383gathered
gettered10258613gettered
gratineed11334473gratineed
greatened1144583greatened
guttered10259163guttered
haltered123112563haltered
happened1635653happened
haptene123810933haptene_
haptenes133810823haptenes
hardened1338613hardened
harkened1637483harkened
hastener11259133hastener
hatted104921513hatt__ed
havened14429243ha_vened
heartened1347063heartened
jittered16267223jittered
ladened979053la_dened
lateener835763lateener
lathered121512333lathered
latten65018203latten__
lattens75014673latten_s
latticed1134793latticed
lettered92910783lettered
listened9168813listened
littered92511383littered
maddened1334893maddened
mastered112614003mastered
matted94521413matt__ed
muttered112610793muttered
neatened937043neatened
paltered113012493paltered
patented1188893pa_tented
patined105114783pa_tined
patted94724683patt__ed
pattee84323383patte_e_
patten84418193patten__
pattens95414923patten_s
patterer103112173patterer
pottered112311663pottered
prattled11246533pratt_led
preattuned1342813preattuned
puttered112611143puttered
rabbeted1334443rabbeted
racemed1237013ra_cemed
racheted14149503racheted
racketed15169123racketed
rafted104714703raft__ed
ragweed1235073ragwe_ed
rained75024603ra__ined
ranted74324703rant__ed
rapiered1136053rapiered
rappeled1335003rappeled
raptured1155473raptured
ratcheted1554783ratcheted
rated65441383ra_t__ed
ratified12310503ratified
ratine65131823ra_tine_
ratines75328583ra_tines
ratline74517803ratline_
ratlines83815293ratlines
ratooner887003ratooner
rattailed1084213rattailed
rattan63613603rattan__
rattans73411953rattan_s
rattening10288763rattening
ratter64326313ratt__er
ratters74422473ratte_rs
rattier74015593ratt_ier
ratting83822363rattin_g
rattle64717613ratt_le_
rattler74012743ratt_ler
rattles73217303ratt_les
ratton64116123ratton__
rattons73815323ratton_s
raveled114113633ra_veled
ravener104110743ra_vener
ravined115411823ra_vined
rawboned14114253rawboned
razeed163710013ra_ze_ed
realtered1037893realtered
reattained1144583reattained
reddened1136423reddened
refastened1443933refastened
reopened1138513reopened
repatterned1452173repatterned
retained93016093retained
retene69224273r_etene_
retenes76324623r_etenes
retted74826313rett__ed
retuned86613973r_etuned
returned9459133returned
reuttered1036073reuttered
richened1435953richened
ripened1038203r_ipened
rotted74524433rott__ed
rotten64115433rotten__
rottenest949603rottenest
rottenly1144153rottenly
rutted74518403rutt__ed
saddened1135343saddened
sauteed8349613saute_ed
scattered12197353scattered
shattered13178203shattered
smartened1244263smartened
smattered12186783smattered
softened1235663softened
spattered12187643spattered
stamened1137633stamened
straitened1143783straitened
tatted74920533tatt__ed
tattled84311483tatt_led
tattooed944573tattooed
tittered9239493tittered
tottered9208703tottered
unattended1242523unattended
unattuned1043343unattuned
uttered82712433_uttered
vatted104214733vatt__ed
waitered1238753waitered
wakened1546873wa_kened
wantoned12117223wantoned
watered113014953wa_tered
wattled113610503watt_led
whitened1535173whitened

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.563317390.8
2DLD Change Limit1461622266.69021847.8
3Display Results2262260.0932430.1
 (SQL Overall)1786912267.34624324.9
 
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.