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

176 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
fattener1126811(None) 
battener10369401battener
fastener11227841fastener
fattened12268281fattened
fatteners12236881fatteners
flattener12175171flattener
rattener8238531rattener
attender935912_attender
battened11259572battened
batteners11238182batteners
batterer102713222batterer
falterer11239872falterer
fastened12257852fastened
fasteners12237062fasteners
fatten94314902fatten__
fattens105111712fatten_s
fatter94523212fatt__er
fattier103513462fatt_ier
fetterer11207812fetterer
flattened13185302flattened
flatteners13164152flatteners
flatterer12187682flatterer
hastener11259142hastener
lateener835762lateener
pattened11299392pattened
patterer103112182patterer
rattened9218622rattened
ratteners9237272ratteners
rottener8216972rottener
aliener71011193_aliener
alterer72714013_alterer
atoner64817193_a_toner
attainer8116913_attainer
attemper12103633_attemper
attend7258973_atten_d
attended1035763_attended
attendee946403_attendee
attenders1045283_attenders
attends8257593_attends
attent62818323_atten_t
attester836503_attester
attune637983_attune_
attuned835173_attuned
attunes737823_attunes
banterer102811783banterer
barrener1038343barrener
bartender1244613bartender
barterer102711643barterer
batten85217123batten__
battens95313263batten_s
batter84928883batt__er
battered113315063battered
batterers113110723batterers
battier93515723batt_ier
battler94113383batt_ler
bitterer10309783bitterer
buttoner1036973buttoner
careener1039333careener
caterer92815953ca_terer
catheter1338153catheter
cattier93317073catt_ier
chastener1445703chastener
chatterer14196843chatterer
clatterer11186993clatterer
dampener1335533dampener
darkener1335993darkener
easterner945063easterner
fainer94717243fa__iner
fakeer13378743fa_ke_er
falconer1346043falconer
falter94519053falt__er
faltered122810993faltered
falterers12238043falterers
fanner94218183fa__nner
farther1348343fart_her
fasten95114893fasten__
fastens105511753fasten_s
faster94625773fast__er
father125116713fa_t_her
fathered151510433fathered
fathomer1645293fathomer
fatted105419843fatt__ed
fattening13287833fattening
fattest102913063fatte_st
fatties103018203fatt_ies
fattiness12239373fattiness
fatting113818703fattin_g
fawner125910463fa__wner
fetter94120383fett__er
fettered12259493fettered
fetterers12267043fetterers
filterer11258143filterer
fitter94120033fitt__er
flatliner12285383flatliner
flatten10429653flatten__
flattens11357483flatten_s
flatter103815963flatt__er
flattered13188633flattered
flatterers13175913flatterers
flutterer12185263flutterer
fosterer11239523fosterer
fritterer12234403fritterer
gardener1037113gardener
gatherer12147913gatherer
haptene123810933haptene_
haptenes133810823haptenes
hardener1238883hardener
harkener1537573harkener
hastened12239103hastened
hasteners12267823hasteners
hatter94724873hatt__er
heartener1256773heartener
kittened1334523kittened
larcener1036493larcener
lateeners945573lateeners
latened8711923la_tened
latherer111310453latherer
latten65018203latten__
lattens75014673latten_s
latter65027893latt__er
letterer8259223letterer
listener8158313listener
litterer82810173litterer
matter84325343matt__er
mattered112412903mattered
mittened1136363mittened
mutterer10218913mutterer
natter64420743natt__er
nattered92011623nattered
nattier73614623natt_ier
oftener1035923_oftener
palterer102411293palterer
parcener1238473parcener
partner92811393part_ner
patienter1145563patienter
pattee84323383patte_e_
patten84418193patten__
pattens95414923patten_s
patter84628263patt__er
pattered112714203pattered
patterers112410133patterers
patterned1265743patterned
potterer102310263potterer
putterer10209913putterer
ratooner887003ratooner
ratteen7329113ratte_en
ratteens8256053ratteens
ratten64217383ratten__
rattens74213403ratten_s
ratter64326313ratt__er
rattier74015593ratt_ier
rattler74012743ratt_ler
ravener104110743ra_vener
scatterer11186293scatterer
shatterer12177203shatterer
smatterer11185813smatterer
softener1145613softener
tatter64024573tatt__er
tattered92011443tattered
tattier74216243tatt_ier
tattler73112213tatt_ler
tattooer844373tattooer
tautened935423tautened
teener64717503__teener
titterer8268523titterer
totterer8217793totterer
utterer71910463_utterer
wakener1446913wa_kener
wantoner1187563wantoner
warrener1136923warrener
waterer103314083wa_terer
watter93221983watt__er
wattmeter1443723wattmeter
whitener1435743whitener
yatter94116213yatt__er
yattered12239533yattered

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.406440125.6
2DLD Change Limit1461621768.68616827.3
3Display Results1761760.1561128.2
 (SQL Overall)1786911769.24819322.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.