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

144 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
fastener1122783(None) 
fastened12257851fastened
fasteners12237051fasteners
fattener11268111fattener
hastener11259131hastener
battener10369392battener
chastener1445702chastener
easterner945052easterner
falterer11239862falterer
fasten95114892fasten__
fastens105511752fasten_s
faster94625772fast__er
fattened12268282fattened
fatteners12236872fatteners
flattener12175172flattener
fosterer11239522fosterer
hastened12239102hastened
hasteners12267812hasteners
listener8158312listener
rattener8238532rattener
aliener71011193_aliener
alterer72714003_alterer
ascender1136733_ascender
assenter867703_assenter
aster55434893_ast__er
atoner64817193_a_toner
attender935913_attender
austerer838383austerer
banterer102811773banterer
barrener1038333barrener
bartender1244603bartender
barterer102711633barterer
baster85333593bast__er
battened11259573battened
batteners11238163batteners
batterer102713213batterer
careener1039333careener
cassene93111543cassene_
cassenes103611293cassenes
castanet10416193castanet
caster85232573cast__er
caterer92815943ca_terer
chastened1545883chastened
chasteners1554793chasteners
dampener1335533dampener
darkener1335993darkener
distender11167743distender
easter65027983east__er
easterners1044823easterners
fainer94717243fa__iner
fakeer13378743fa_ke_er
falconer1346043falconer
falter94519053falt__er
faltered122810993faltered
falterers12238033falterers
fanner94218183fa__nner
farther1348343fart_her
fascine12510583fascine_
fascines13310143fascines
fashioner15114323fashioner
fasted105320953fast__ed
fastening13268603fastening
fastest102413723faste_st
fasting114522833fastin_g
fastings124011943fastings
fastness11238763fastness
father125116713fa_t_her
fatten94314903fatten__
fattens105111713fatten_s
fatter94523213fa_t_ter
fattier103513463fa_ttier
fawner125910463fa__wner
feaster10812983feast__er
fester94723513fest__er
festered122512113festered
fetterer11207813fetterer
filterer11258143filterer
flattened13185303flattened
flatteners13164153flatteners
flatterer12187683flatterer
foster94322223fost__er
fostered122210453fostered
fosterers12238023fosterers
freshener1544853freshener
fustier104213933fust_ier
gardener1037103gardener
gaster75027353gast__er
haptene123810933haptene_
haptenes133810823haptenes
hardener1238883hardener
harkener1537573harkener
hasten95718563hasten__
hastens106214813hasten_s
hastier103916623hast_ier
heartener1256763heartener
hosteler1137283hosteler
larcener1036493larcener
laster64830633last__er
lateener835763lateener
latened8711923la_tened
listened9168813listened
listeners9147323listeners
masseter1037063masseter
master84831343mast__er
mastered112614003mastered
moistener1145843moistener
nastier74115293nast_ier
obscener1244323obscener
oftener1035923_oftener
oysterer1136103oysterer
palterer102411283palterer
parcener1238473parcener
partner92811393part_ner
passenger1243413passenger
paster85734373past__er
pastier94320383past_ier
pasturer1037523pasturer
pattened11299393pattened
patterer103112173patterer
pesterer102412713pesterer
plasterer1178113plasterer
raster64731443rast__er
rattened9218623rattened
ratteners9237263ratteners
ravener104110743ra_vener
refastened1443933refastened
rottener8216973rottener
softener1145613softener
steer55423863__ste_er
sterner7411913__sterner
stoner65823203__stoner
taster64930573tast__er
tastier711817093tast_ier
tautened935423tautened
unfastened1443243unfastened
vaster94521023vast__er
vastier103613203vast_ier
wakener1446913wa_kener
wantoner1187563wantoner
warrener1136913warrener
waster95228943wast__er
waterer103314073wa_terer
westerner1244963westerner
whitener1435733whitener

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.410435831.7
2DLD Change Limit1461621447.00020880.3
3Display Results1441440.0602400.0
 (SQL Overall)1786911447.47023921.2
 
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.