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

129 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
darkening153568(None) 
harkening1746921harkening
bedarkening1942192bedarkening
careening12310012careening
dackering1737382dackering
daikering1536102daikering
dampening1535462dampening
darking134217342dark__ing
darkling1437482dark_ling
darning93817332dar__ning
davening13258872da_vening
gardening1236512gardening
hardening1438022hardening
hearkening1844532hearkening
marketing1636512marketing
wakening1636322wa_kening
aliening91510893_aliening
awakening1743203awakening
barbering14229683barbering
barkentine16103773barkentine
barking144724183bark__ing
barning104320353bar__ning
barreling1238043barreling
bartending1444913bartending
bartering122313643bartering
battening12268853battening
blackening1944793blackening
brazening2185183brazening
burdening1335543burdening
cankering162110793cankering
careering12311203careering
carking144322853cark__ing
carpeting1439483carpeting
cartoning12311113cartoning
casketing1635383casketing
coarsening1345543coarsening
cravening1547553cravening
daggering13246113daggering
damning114211633da__mning
dandering122511063dandering
dangering12239303dangering
daring84928683dar___ing
darken114013443darke__n_
darkened1435943darken_ed
darkener1335993darken_er
darkeners1435153darkeners
darkens12409873darke__ns
darklings1533983dark_lings
darling93418363dar__ling
darnings10378553dar__nings
darting94020663dar__ting
dartling1039563dar_tling
dawning124111013da__wning
deadening1277583deadening
deafening1476273deafening
deepening1335613deepening
dekeing13358353d_eke_ing
dickering1737463dickering
dirking133812603dirk__ing
dizening19177143d_izening
docketing1785413docketing
dovening13238353d_ovening
dozening19236183d_ozening
draining103312673d_raining
dreeing94311183d_r_eeing
droning93013723d_r_oning
drowning13298363d_rowning
durning93511733dur__ning
earning83418213ear__ning
farseeing1344383farseeing
fastening13268603fastening
fattening13287833fattening
garmenting1445483garmenting
garnering11298083garnering
gartering112111573gartering
greening103112533_greening
hankering17239383hankering
happening1735593happening
hardenings1544243hardenings
harking154120943hark__ing
harshening1744173harshening
hastening13259483hastening
havening15258553ha_vening
heartening1446733heartening
hoarsening1444403hoarsening
jacketing2345643jacketing
jargoning1845983jargoning
lackering1639373lackering
lackeying1934923lackeying
ladening1078823la_dening
larking123718253lark__ing
latening9711493la_tening
likening13246893_likening
maddening1445113maddening
margenting1446153margenting
margining1337603margining
marketings1743163marketings
marking144020133mark__ing
marooning1238593marooning
marveling1537103marveling
narking124015383nark__ing
packeting1836853packeting
parceling1438443parceling
pardoning1338763pardoning
parenting12611583par_enting
pargeting1338283pargeting
parking143423043park__ing
parleying1536113parleying
pinkening1634993pinkening
preening113115843_preening
racketing1647873racketing
rattening10288763rattening
ravening122611293ra_vening
saddening1245213saddening
sardining1137573sardining
screening1247183screening
sharpening1644883sharpening
sickening1635993sickening
slackening1744343slackening
smartening1344993smartening
targeting1137303targeting
tautening1035843tautening
tokening1336463_tokening
wakenings1743043wa_kenings
warking153519573wark__ing
warning113717093war__ning
weakening1734843weakening
worsening1345553worsening
yarning113512953yar__ning

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.1561145455.1
2DLD Change Limit1486411297.37620152.0
3Display Results1291290.0462804.3
 (SQL Overall)1786911297.57823580.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.