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 “darndest” 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
darndest106722(None) 
damndest1276001damndest
darndests1183141darndests
darnedest1145251darnedest
durndest1065761durndest
aridest8316142_aridest
barniest104815052barniest
damndests1392792damndests
damnedest1344332damnedest
dandiest103415032da_ndiest
dankest122611672da_nkest
darkest122512622dar_kest
darnedests1242232darnedests
durnedest1144082durnedest
earnest7318732earn_est
grandest10311572grandest
hardest113118412har_dest
acridest1138143acridest
ardent73022613_ar_dent
armrest9310163_armrest
arrest63722633_ar_rest
artiest73121993_artiest
auldest839893_auldest
baddest112611143ba_ddest
baldest102313533ba_ldest
bardes95026933bar_des_
barest85327693bar__est
barghest1447913barghest
barguest1137163barguest
barkiest144115153barkiest
barmiest125212783barmiest
blandest113811043blandest
blindest11609093blindest
blondest11419243blondest
candent10417363ca_ndent
canniest10313363canniest
carnet84732873carn_e_t
carnets93918403carn_ets
carnies94123963carnies_
corniest102117303corniest
crankest1438143crankest
crudest104510333_crudest
daffiest1537843daffiest
daftest11248943da_ftest
daintiest1039153daintiest
damnedests1451593damnedests
dampest12411043da_mpest
dances95120653da_nces_
dander811222993da_nde_r
danders93921183da_nders
dandies94121443da_ndies_
dandles94218533da_ndles_
darbies104216983darbies_
dares66146703dar__es_
darkies124015753darkies_
darkles124011933darkles_
darkliest1435163darkliest
darkness13247343darkness
darned85018483darn_e_d
darneder1033983darneder
darnel74312183darn_e_l
darnels83710433darn_els
darner74017303darn_e_r
darners83815773darn_ers
darns66927893darn__s_
dartles84014133dartles_
dashiest12311113dashiest
daubiest1138233daubiest
daunder9348893daunde_r
daunders10278473daunders
deadest93014883d_eadest
dearest83618673dear__est
dearness939973dearn_ess
densest83112473d_ensest
derides93420853derides_
direst75024243dir__est
dirndls933893dirndls_
dirtiest93014203dirtiest
dorkiest133111253dorkiest
downiest122710603downiest
drabbest13295663drabbest
drest65530343d_r__est
driest74722753d_r_iest
drunkest1334423drunkest
dryest104811123d_r_yest
duendes938193duendes_
dunnest83312263d_unnest
dwarfest1543473dwar_fest
earliest82415243earliest
earnests837853earn_ests
fainest10417703fain_est
faintest1139073faintest
farness102912203farn_ess
farthest1499863farthest
fawniest14287443fawniest
ferniest1132214153ferniest
fondest11312403_fondest
frankest1536963frankest
garnet73928413garn_e_t
garnets84115403garn_ets
gauntest936603gauntest
haddest122711993ha_ddest
handiest123417773ha_ndiest
handset113016823ha_ndset
hardiest123416333hardiest
hardness122411083hardness
hardset113415833har_dset
harness102413933harn_ess
harshest14310193harshest
harvest132112753har_vest
horniest112814043horniest
kindest12311503_kindest
lankest112714113la_nkest
lardiest93813883lardiest
largest83715103lar_gest
larkiest123713313larkiest
maddest112311213ma_ddest
marliest102415183marliest
nakedest1345473nakedest
pandect12310953pa_ndect
parades104121463parades_
parodist11412763parodist
porniest103214313porniest
rainiest81214923rainiest
randiest93418773ra_ndiest
rankest112713813ra_nkest
rapidest1138543rapidest
rarest65725483rar__est
roundest9310473roundest
rudest74016313__rudest
saddest92412383sa_ddest
sandiest93218683sa_ndiest
sanest64426693sa_n_est
sarkiest123615063sarkiest
sarodes84216143sarodes_
sarodist9510923sarodist
scaredest1246633scaredest
soundest9510973soundest
tannest72617853ta_nnest
tardiest93515243tardiest
tarriest83215003tarriest
tartest72517533tar_test
tartiest82718313tartiest
tawniest11279343tawniest
tiredest938403tiredest
vainest10315763vain_est
waniest103819113wa_niest
wannest103915003wa_nnest
wariest105122503war_iest
warmest123113033war_mest
wartiest113614643wartiest
yarest95018913yar__est
zaniest163214773za_niest

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.436409841.7
2DLD Change Limit1461621537.82618676.5
3Display Results1531530.0632428.6
 (SQL Overall)1786911538.32521464.4
 
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.