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

181 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
earnests83785(None) 
earnest7318731earnest_
arrests73312692_arrests
carnets93918402carne_ts
darndests1183142darndests
dearness939972dearnes_s
earless74316072earles_s
earners74016452earne_rs
earnestly1243012earnestly
farness102912202farnes_s
garnets84115412garne_ts
harness102413932harnes_s
harvests14246172harvests
nearness838312nearnes_s
rearrests945312rearrests
aeriest73924053aeriest_
amnesty1244823_amnesty
angsts738863_a_ngsts
argents84014853_argents
armets84918353_arme_ts
armrests1055393_armrests
arpents93613083_arpents
arrest63722633_arrest_
artists74215603_artists
attests7278813_attests
badness1039573badnes_s
bannets94013843banne_ts
barbets114915853barbe_ts
bareness10912813barenes_s
barest85327693bar_est_
barghests1543313barghests
barguests1243483barguests
barless94317003barles_s
barneys12569563barne_ys
barniest104815053barniest_
baroness101210063barones_s
baronets101410913barone_ts
barrets94917113barre_ts
burnets93813263burne_ts
caress85720263car_es_s
carets85330773car_e_ts
carless95118493carles_s
carnet84732873carne_t_
carneys124310543carne_ys
carpets113915333carpe_ts
clearness1135633clearnes_s
cornets94820573corne_ts
crests85218703_cr_ests
damndests1392793damndests
darkest122512623darkest_
darkness13247343darknes_s
darndest1067223darndest_
darnedests1242233darnedests
darnels83710433darne_ls
darners83815773darne_rs
deadness1039233deadnes_s
deafness1236213deafnes_s
dearest83618673dear_est_
dearnesses1139583dearnesses
eagerness1046263eagernes_s
eaglets84111663eagle_ts
earliest82415243earliest_
earliness939713earlines_s
earned74818333earne__d
earner63617223earne__r
earnestness1152813earnestness
earnings9419333earnings
earns55927563earn___s
earshots1146623earshots
earthsets1244123earthsets
easiest72318773easiest_
easiness8313043easines_s
easts57530323ea___sts
eeriest73620673eeriest_
eeriness8311873eerines_s
egests74411253e__gests
egress73310433egr_es_s
egrets72712243egr_e_ts
erects84116183e_r_ects
ernes55224813e_rne__s
evenest10312103evenest_
fainest10417703fainest_
fairness1136563fairnes_s
farnesol11113013farnesol
farnesols12102743farnesols
farnesses122310813farnesses
fatness103311293fatnes_s
fearless1137873fearles_s
forests104114953for_ests
gabfests1442383gabfests
gannets83811443ganne_ts
gargets94614573garge_ts
garments1139973garments
garners83815993garne_rs
garnet73928413garne_t_
garrets84413623garre_ts
gayness1136843gaynes_s
gearless937373gearles_s
gurnets84010793gurne_ts
hairnets1195633hairne_ts
hangnests1344543hangnests
hardest113118413hardest_
hardness122411083hardnes_s
harnesses121812073harnesses
harpists1338103harpists
harvest132112753harvest_
headrests13245023headrests
hornets104113553horne_ts
hornists11208833hornists
karsts106012953kar__sts
largess8408913larges_s
largest83715103largest_
latests73910313la_tests
laxness1436043laxnes_s
leanest7415863lea_nest_
leanness837373leannes_s
leariest83117853leariest_
learners8398153learne_rs
madness10310073madnes_s
magnets10311143magne_ts
margents11410133margents
markets133314033marke_ts
meanest9315703mea_nest_
meanness1037183meannes_s
narcists1078113narcists
nearest73415843near_est_
nearnesses1039113nearnesses
neatness839153neatnes_s
nests55728003___nests
oarless73913373oarles_s
parents93418133par_ents
pareses94718883par_eses
paresis93315093par_esis
pargets105215193parge_ts
patness92912283patnes_s
peartest10311303peartest_
peartness1137773peartnes_s
prests84021263_pr_ests
priests93810863_priests
rareness81112853rarenes_s
rarest65725483rar_est_
rawness1038153rawnes_s
realness8410443realnes_s
rearrest8311603rearrest_
reests64618893__reests
renests74014213_renests
rests54935873__r_ests
sadness8310613sadnes_s
sanest64426693sa_nest_
sarments10311963sarments
sarsnets836783sarsne_ts
searest73322023sear_est_
tanists7313663ta_nists
tannest72617853tannest_
targets84314223targe_ts
tartest72517533tartest_
tartness82210133tartnes_s
teariest82417263teariest_
teariness9310633tearines_s
tearless848713tearles_s
trapnests1144433trapnests
unrests7229463unr_ests
vainest10315763vainest_
varlets10411573varle_ts
varments1339063varments
waeness102512783waenes_s
wanness102610683wannes_s
wannest103915003wannest_
wariest105122503wariest_
wariness11313223warines_s
warless104015103warles_s
warmest123113033warmest_
warmness1337063warmnes_s
warners103315563warne_rs
weakness1535353weaknes_s
weariest112914793weariest_
weariness1238843wearines_s
wrests95313083_wr_ests
yarest95018913yar_est_
yarners104312203yarne_rs
yearners11346373yearne_rs

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.420425454.8
2DLD Change Limit1461621818.17317883.5
3Display Results1811810.0802262.5
 (SQL Overall)1786911818.67320603.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.