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) 
battener10369391battener
fastener11227831fastener
fattened12268281fattened
fatteners12236871fatteners
flattener12175171flattener
rattener8238531rattener
attender935912_attender
battened11259572battened
batteners11238162batteners
batterer102713212batterer
falterer11239852falterer
fastened12257852fastened
fasteners12237052fasteners
fatten94314902fatten__
fattens105111712fatten_s
fatter94523212fatt__er
fattier103513462fatt_ier
fetterer11207812fetterer
flattened13185302flattened
flatteners13164152flatteners
flatterer12187672flatterer
hastener11259132hastener
lateener835762lateener
pattened11299392pattened
patterer103112172patterer
rattened9218622rattened
ratteners9237262ratteners
rottener8216972rottener
aliener71011193_aliener
alterer72713993_alterer
atoner64817193_a_toner
attainer8116913_attainer
attemper12103633_attemper
attend7258973_atten_d
attended1035763_attended
attendee946403_attendee
attenders1045273_attenders
attends8257593_attends
attent62818323_atten_t
attester836503_attester
attune637983_attune_
attuned835173_attuned
attunes737823_attunes
banterer102811773banterer
barrener1038333barrener
bartender1244603bartender
barterer102711633barterer
batten85217123batten__
battens95313263batten_s
batter84928873batt__er
battered113315053battered
batterers113110713batterers
battier93515713batt_ier
battler94113383batt_ler
bitterer10309773bitterer
buttoner1036973buttoner
careener1039333careener
caterer92815943ca_terer
catheter1338153catheter
cattier93317073catt_ier
chastener1445703chastener
chatterer14196843chatterer
clatterer11186983clatterer
dampener1335533dampener
darkener1335993darkener
easterner945053easterner
fainer94717243fa__iner
fakeer13378743fa_ke_er
falconer1346033falconer
falter94519053falt__er
faltered122810983faltered
falterers12238033falterers
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
flattered13188623flattered
flatterers13175913flatterers
flutterer12185263flutterer
fosterer11239523fosterer
fritterer12234403fritterer
gardener1037103gardener
gatherer12147903gatherer
haptene123810933haptene_
haptenes133810823haptenes
hardener1238883hardener
harkener1537573harkener
hastened12239103hastened
hasteners12267813hasteners
hatter94724873hatt__er
heartener1256763heartener
kittened1334523kittened
larcener1036493larcener
lateeners945563lateeners
latened8711923la_tened
latherer111310443latherer
latten65018203latten__
lattens75014673latten_s
latter65027893latt__er
letterer8259223letterer
listener8158313listener
litterer82810173litterer
matter84325343matt__er
mattered112412903mattered
mittened1136363mittened
mutterer10218913mutterer
natter64420743natt__er
nattered92011623nattered
nattier73614623natt_ier
oftener1035923_oftener
palterer102411273palterer
parcener1238473parcener
partner92811393part_ner
patienter1145553patienter
pattee84323383patte_e_
patten84418193patten__
pattens95414923patten_s
patter84628263patt__er
pattered112714203pattered
patterers112410123patterers
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
warrener1136913warrener
waterer103314073wa_terer
watter93221983watt__er
wattmeter1443723wattmeter
whitener1435733whitener
yatter94116213yatt__er
yattered12239533yattered

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.440406115.9
2DLD Change Limit1461621767.20320291.8
3Display Results1761760.0762315.8
 (SQL Overall)1786911767.71923149.5
 
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.