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

159 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
hastener1125913(None) 
chastener1445701chastener
fastener11227831fastener
hastened12239101hastened
hasteners12267811hasteners
battener10369392battener
chastened1545882chastened
chasteners1554792chasteners
easterner945052easterner
fastened12257852fastened
fasteners12237052fasteners
fattener11268112fattener
haptene123810932haptene_
haptenes133810822haptenes
hardener1238882hardener
harkener1537572harkener
hasten95718562hasten__
hastens106214812hasten_s
hastier103916622hast_ier
heartener1256762heartener
hosteler1137282hosteler
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
charterer14197323charterer
chasten124312403chasten__
chasteness1546523chasteness
chastens13429183chasten_s
chaster124718503chast__er
chastiser1444373chastiser
chatterer14196843chatterer
dampener1335533dampener
darkener1335993darkener
distender11167743distender
easter65027983east__er
easterners1044823easterners
falterer11239863falterer
fasten95114893fasten__
fastens105511753fasten_s
faster94625773fast__er
fattened12268283fattened
fatteners12236873fatteners
flattener12175173flattener
fosterer11239523fosterer
gardener1037103gardener
gaster75027353gast__er
ghastlier1342893ghastlier
hafter124815883haft__er
halter94420883halt__er
haltere103614713haltere_
haltered123112563haltered
halteres113414603halteres
hammerer15278143hammerer
hamperer15379093hamperer
hamster12810423hamst__er
hankerer15248233hankerer
happened1635653happened
hapten115312983hapten__
haptenic1545763haptenic
haptens124511343hapten_s
hardened1338613hardened
hardeners1338083hardeners
harkened1637483harkened
harkeners1636073harkeners
harshened1644453harshened
hastate10313913hastate_
haste85927863hast__e_
hasted105125283hast__ed
hasteful14105253hasteful
hastening13259483hastening
hastes95727073hast__es
hastiness122410883hastiness
hasting114725193hastin_g
hatcher153314723ha_tcher
hater85034753ha_t__er
hatter94724873ha_t_ter
hauteur1033893haute_ur
havened14429243ha_vened
hearkener1644213hearkener
heartened1347063heartened
hearteners1346213hearteners
histone10312843histone_
histones11312803histones
hosteled1237293hosteled
hostelers1246643hostelers
hosteller1245863hosteller
hostler103411023host_ler
hustler103410753hust_ler
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
rottener8216973rottener
sharpener1444583sharpener
shatterer12177203shatterer
shortener1245773shortener
softener1145613softener
steer55423863__ste_er
sterner7411913__sterner
stoner65823203__stoner
taster64930573tast__er
tastier711817093tast_ier
tautened935423tautened
vaster94521023vast__er
vastier103613203vast_ier
wakener1446913wa_kener
wantoner1187563wantoner
warrener1136913warrener
waster95228943wast__er
waterer103314073wa_terer
westerner1244963westerner
whatever1742673wha_tever
whitener1435733whitener

Search took 9 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.453394461.4
2DLD Change Limit1461621597.87318565.0
3Display Results1591590.0632523.8
 (SQL Overall)1786911598.38921300.6
 
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.