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

224 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
battened1125957(None) 
battener10369391battener
battered113315051battered
fattened12268281fattened
pattened11299391pattened
rattened9218621rattened
attend7258972_atten_d
attended1035762_attended
attuned835172_attuned
bantered113313632bantered
bartend1038752barten_d
bartended1344662bartended
bartered113113012bartered
batted95623652batt__ed
batten85217122batten__
batteners11238162batteners
battens95313262batten_s
batterer102713212batterer
battled104213122batt_led
bettered113011832bettered
bittered112711832bittered
blattered12198562blattered
buttered112712622buttered
buttoned1137502buttoned
fastened12257852fastened
fattener11268112fattener
flattened13185302flattened
hastened12239102hastened
kittened1334522kittened
latened8711922la_tened
mattered112412902mattered
mittened1136362mittened
nattered92011622nattered
pattered112714202pattered
patterned1265742patterned
rattener8238532rattener
tattered92011442tattered
tautened935422tautened
yattered12239532yattered
aliened81011743_aliened
altered83215733_altered
anteed75616113_ante_ed
atoned75417543_a_toned
attained997353_attained
attendee946403_attendee
attender935913_attender
attends8257593_attends
attent62818323_atten_t
attested936293_attested
attired8238913_attired
attorned955353_attorned
attune637983_attune_
attunes737823_attunes
badgered1336213badgered
baited95319243bait__ed
baned85436353ba___ned
banned94721343ba__nned
bannered11299323bannered
banteng1046363banten_g
bantengs1134593bantengs
banterer102811773banterer
baptised1335263baptised
baptized2245483baptized
barbered13259543barbered
barned95623583ba__rned
barreled1137843barreled
barrener1038333barrener
bartender1244603bartender
bartends1136793bartends
barterer102711633barterer
basined10310003ba_sined
basseted1136743basseted
basted95227233bast__ed
bastioned1246863bastioned
batched154114243ba_tched
bated85935533ba_t__ed
bathed125518743ba_t_hed
batiked1435963ba_tiked
batmen104414303batmen__
batteau936343batte_au
batteaux1742503batteaux
battement1357773battement
battening12268853battening
batter84928873batt__er
batterers113110713batterers
batterie10711533batterie
batteries11615113batteries
batters94626013batte_rs
battery124911813batte_ry
battier93515713batt_ier
battiness11239843battiness
batting104422273battin_g
battings114010573battings
battle85217863batt_le_
battler94113383batt_ler
battles94517683batt_les
battue84311003batt_ue_
battues94610193batt_ues
betattered1343143betattered
betokened1643403betokened
betted94721163bett__ed
bistered112913323bistered
bitted94418483bitt__ed
bitten84715123bitten__
bitterer10309773bitterer
blackened1845273blackened
blathered15168353blathered
blatted104812713blatt__ed
bothered142110393bothered
bottled104611233bott_led
bottomed1344673bottomed
bratticed1443283bratticed
brattled11196723bratt_led
brazened20134903brazened
burdened1236423burdened
burthened1543963burthened
butene8312623b_utene_
butenes9313033b_utenes
butted94722063butt__ed
buttoner1036973buttoner
caftaned1445093caftaned
cantered113415983cantered
cantoned111411523cantoned
careened1139193careened
cartoned111312833cartoned
catered103117773ca_tered
catted95422473catt__ed
chastened1545883chastened
chattered15197993chattered
clattered12178403clattered
coattend1134653coatten_d
coattended1443103coattended
cottered112511733cottered
cottoned1138033cottoned
dampened1435623dampened
darkened1435943darkened
davened124610073da_vened
faltered122810983faltered
fastener11227833fastener
fathered151510433fathered
fatted105419843fatt__ed
fatten94314903fatten__
fatteners12236873fatteners
fattens105111713fatten_s
fettered12259493fettered
flattener12175173flattener
flattered13188623flattered
gardened1137003gardened
gartered10319583gartered
gathered13149373gathered
gettered10258613gettered
guttered10259163guttered
haltered123112553haltered
happened1635653happened
haptene123810933haptene_
haptenes133810823haptenes
hardened1338613hardened
harkened1637483harkened
hastener11259133hastener
hatted104921513hatt__ed
havened14429243ha_vened
heartened1347063heartened
jittered16267223jittered
ladened979053la_dened
lateener835763lateener
lathered121512323lathered
latten65018203latten__
lattens75014673latten_s
latticed1134793latticed
lettered92910783lettered
listened9168813listened
littered92511383littered
maddened1334893maddened
mastered112614003mastered
matted94521413matt__ed
muttered112610793muttered
neatened937043neatened
paltered113012483paltered
patented1188893pa_tented
patined105114783pa_tined
patted94724683patt__ed
pattee84323383patte_e_
patten84418193patten__
pattens95414923patten_s
patterer103112173patterer
pottered112311663pottered
puttered112611143puttered
raftered1237663raftered
rationed9410093rationed
ratooned977103ratooned
ratted74923343ratt__ed
ratteen7329113ratte_en
ratteens8256053ratteens
ratten64217383ratten__
ratteners9237263ratteners
rattens74213403ratten_s
rattled84012953ratt_led
rattooned1043843rattooned
ravened115012283ra_vened
rottener8216973rottener
saddened1135343saddened
sauteed8349613saute_ed
scattered12197353scattered
shattered13178203shattered
smartened1244263smartened
smattered12186783smattered
softened1235663softened
spattered12187643spattered
stamened1137633stamened
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.1561145455.1
2DLD Change Limit1461622247.15620425.1
3Display Results2242240.0932408.6
 (SQL Overall)1786912247.40524131.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.