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

153 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
hastening1325948(None) 
chastening1656521chastening
fastening13268601fastening
battening12268852battening
fastenings14273902fastenings
fattening13287832fattening
haltering132212002haltering
happening1735592happening
hardening1438022hardening
harkening1746922harkening
harshening1744172harshening
hasting114725192hast__ing
havening15258552ha_vening
heartening1446732heartening
hosteling1337892hosteling
latening9711492la_tening
listening10128952listening
mastering122315302mastering
rattening10288762rattening
tautening1035842tautening
aliening91510893_aliening
altering91917113_altering
anteing8312813_ante_ing
ascending1336283_ascending
assenting1038163_assenting
astonying1345233_astonying
atoning83514873_a_toning
attending11136373_attending
attuning935903_attuning
bantering122414233bantering
bartending1444913bartending
bartering122313643bartering
basseting1236153basseting
basting104227203bast__ing
battering122715143battering
cantering122417373cantering
cantoning12310883cantoning
careening12310013careening
cartoning12311113cartoning
casketing1635383casketing
casting104628343cast__ing
castling11311233cast_ling
catering112019903ca_tering
chaptering18107963chaptering
chartering16109253chartering
chasseing1554963chasse_ing
chastising1654883chastising
chattering16108643chattering
christening1743403christening
dampening1535463dampening
darkening1535683darkening
davening13258873da_vening
destining11311433destining
distending1348333distending
easting84924303east__ing
faltering132211113faltering
fasting114522833fast__ing
festering132413173festering
flattening14115103flattening
fostering132411263fostering
gardening1236513gardening
gartering112111573gartering
gasting95022763gast__ing
glistening1294283glistening
haeing104118923ha__e_ing
hafting144014173haft__ing
halting114419073halt__ing
hamboning1745893hamboning
hammering1737633hammering
hampering1738863hampering
hamstring1546003hamst_ring
hankering17239383hankering
hanseling1338063hanseling
hanting114124483hant__ing
happenings1842623happenings
haptenic1545763hapteni_c
hardenings1544243hardenings
hashing145020163has__hing
hasping134414903has__ping
hassling1236803has_sling
hasten95718563haste__n_
hastened12239103hasten_ed
hastener11259133hasten_er
hasteners12267813hasteners
hastens106214813haste__ns
hatching173312213ha_tching
hating104929713ha_t__ing
hatting113920233ha_t_ting
havering152211053ha_vering
hearkening1844533hearkening
histing113720373hist__ing
hoarsening1444403hoarsening
hoidening1435633hoidening
holstering1447083holstering
hoseying1537193hos_eying
hostelling1446163hostelling
hostessing1444573hostessing
hosting114318383host__ing
hoydening1744353hoydening
hustling12228793hust_ling
hyphening2144133hyphening
kashering1736253kashering
kittening1434593kittening
ladening1078823la_dening
lasting84725243last__ing
lessening1045333lessening
lustering102711203lustering
maddening1445113maddening
masoning1139763mas_oning
masting104325823mast__ing
mattering122314053mattering
mistending1447953mistending
mistuning1237673mistuning
moistening1346233moistening
mustering122212333mustering
nattering102212213nattering
neatening1038353neatening
oystering1337563oystering
paltering122612893paltering
pasting103826553past__ing
pastoring12310853pastoring
pasturing1238433pasturing
patenting1248943pa_tenting
patining11312303pa_tining
pattering122314423pattering
patterning1346073patterning
pestering122315663pestering
plastering1339243plastering
ravening122611293ra_vening
refastening1544303refastening
saddening1245213saddening
sauteing937913saute_ing
sharpening1644883sharpening
shattering1498283shattering
shortening1445303shortening
sistering101213753sistering
smartening1344993smartening
softening1365493softening
staning83922243__staning
stewing113412493__stewing
stoning83717443__stoning
tasseling1035853tasseling
tasting84624213tast__ing
tattering102212323tattering
unfastening1572783unfastening
waitering13310713waitering
wakening1636323wa_kening
wantoning1337083wantoning
wasting114422843wast__ing
watering122316313wa_tering
westering132112643westering
whitening1635103whitening
yattering132410443yattering

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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411536.76621968.8
3Display Results1531530.0762013.2
 (SQL Overall)1786911537.01525472.7
 
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.