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

420 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
nearest7341584(None) 
dearest83618671dearest
neatest72516001neatest
searest73322021searest
barest85327692_barest
clearest1038652clearest
deadest93014882deadest
deafest112911512deafest
earnest7318732_earnest
featest102715112featest
headrest122910202headrest
leanest7415862leanest
leariest83117852leariest
meanest9315702meanest
merest84725112me_rest
nares55544152n_ares_
neared75119812neare_d
nearer64618892neare_r
nearliest949362nearliest
nearness838312nearness
nears55529422near_s_
newest9314212ne_west
peartest10311302peartest
rarest65725482_rarest
realest73322432realest
rearrest8311602rearrest
serest64831612se_rest
sparest94616432sparest
teariest82417262teariest
weakest1439002weakest
weariest112914792weariest
yarest95018912_yarest
addrest958633addrest
aeriest73924053aeriest
airest63825263_airest
anapest9311563anapest
aneared8512743aneare_d
anears63717183anear_s_
ares45871023__ares_
armrest9310163armrest
arrest63722633_arrest
bares75457133_bares_
basest84720493_basest
beadiest113815533beadiest
beakiest143313463beakiest
beamiest123212763beamiest
bearcat11611913bearcat
beards94116673beards_
bearer85323913beare_r
bearers94619593bearers
bearish123013273bearish
bears75739043bear_s_
beast76338643bea__st
becrust1137983becrust
beeriest104013403beeriest
befret11315963befre_t
befrets1237613befrets
behest11314613be_hest
bequest1837823bequest
bereft114317303be_reft
beret74946363be_re_t
berets85822523be_rets
bewares12313373bewares_
blares85021633blares_
bleakest1436283bleakest
bleariest1158853bleariest
bravest124211753bravest
brawest123810483brawest
cares77369183_cares_
caress85720263_caress
caret75360563_care_t
carets85330773_carets
ceases84427073ceases_
ceres75540013ce_res_
chares115631803chares_
chariest13315513chariest
cheapest1536073cheapest
claret84026573clare_t
clarets94111103clarets
cleanest10310293cleanest
coarsest1039163coarsest
crest74632693__crest
czarist18710223czarist
dares66146703_dares_
darkest122512623_darkest
dearer74822803deare_r
dearies83526273dearies_
dearness939973dearness
dears65736883dear_s_
deaves105319533deaves_
decares102818533decares_
deepest10310443deepest
deffest14308813deffest
deforest1238793deforest
defrost1139553defrost
deftest112611713deftest
dekares122710873dekares_
demurest1137453demurest
densest83112473densest
depress10239873depress
detest74122843de_test
devest104418703de_vest
dewiest11312343dewiest
diarist8517113diarist
direst75024243_direst
dourest8312943dourest
dreariest10229123dreariest
drest65530343__drest
dwarfest1543473dwarfest
eagerest9510273_eagerest
eagres74014573_eagres_
eared65139503_eare_d
earless74316073_earless
earliest82415243_earliest
earls56127513_earls_
earnests837853_earnests
earns55927563_earns_
ears46356593_ear_s_
eases56041613_eases_
easiest72318773_easiest
east46659103_ea__st
eaves85231993_eaves_
eeliest73516473eeliest
eeriest73620673eeriest
egest65222343_e_gest
egress73310433_egress
egret63327313_egre_t
egrets72712243_egrets
eldest72912683_eldest
enates64026433enates_
encrust947873encrust
entreat7315263entreat
entrust7410883entrust
enures63919713enures_
erect74129333_e_rect
erst47436433_e_r_st
eyres84921773_eyres_
fairest10412293fairest
fares85852873_fares_
feared106320433feare_d
fearer94820183feare_r
fearers104815273fearers
fearless1137873fearless
fears84829393fear_s_
feases95422923feases_
feast85932723fea__st
feazes184514173feazes_
fellest10313753fellest
feres86038183fe_res_
ferret93021173ferre_t
ferrets103111393ferrets
fewest12311663fe_west
feyest12311403fe_yest
flares94521703flares_
forest94926743_forest
gamest94919933_gamest
gayest104314333_gayest
geared85317743geare_d
gearless937373gearless
gears64628693gear_s_
geest64829623ge__est
genres75515623genres_
gerent73223103ge_rent
glares75518873glares_
glariest92012533glariest
gravest114011633gravest
grayest11489363grayest
greatest939863greatest
haeres94017033haeres_
halest94823273_halest
hardest113118413_hardest
hares86255543_hares_
harvest132112753_harvest
headiest123015553headiest
headrests13245023headrests
headset11312603headset
hearer94323653heare_r
hearers104319783hearers
hears86737373hear_s_
hearse94114283hear_se
hearsed113811423hearsed
hearses104414543hearses
heart85440743hear__t
heartiest12311103heartiest
hearts96218943hearts_
heaves124120303heaves_
heaviest143210443heaviest
heiress1036813heiress
heppest14228153heppest
hereat93527413he_reat
heres86245903he_res_
heresy125011233he_resy
hoariest11312883hoariest
hoarsest1137133hoarsest
imaret81121233imare_t
imarets9138643imarets
imprest11310203imprest
inanest72115363inanest
infares10313023infares_
insanest8410343insanest
interest8319183interest
iratest7312483iratest
karst97229003_kar_st
keenest11410963keenest
lamest84722763_lamest
lares54852633_lares_
largest83715103_largest
latest63822703_latest
laxest134913363_laxest
leadiest93314993leadiest
leafiest113410893leafiest
leakiest123212803leakiest
learns65513743learns_
learnt64019253lear_nt
lears55938733lear_s_
leases65428113leases_
least56134883lea__st
leaves94222383leaves_
leaviest112910823leaviest
leeriest83112883leeriest
leftest10269463leftest
lewdest1136283lewdest
mares76457633_mares_
mayest114614793_mayest
mealiest102215973mealiest
meatiest102816793meatiest
meekest1336893meekest
meres75143573me_res_
merriest10311483merriest
metres85121563metres_
metrist9317063metrist
nabes75427093n_abes_
nacres85614453nacres_
naivest10309473naivest
names74833363n_ames_
napes74828463n_apes_
narcist9512443n_arcist
narcs76122023n_arcs_
nards65928463n_ards_
naris55735293n_aris_
narks96026033n_arks_
nates55238333n_ates_
naves87030383n_aves_
neaps75618323nea_ps_
near45236503near___
nearby11356053near_by
nearing83020333nearing
nearly94813733near_ly
neat46356783nea___t
neaten64214543neate_n
neatens73310403neatens
neater64424313neate_r
neatness839153neatness
neats55931903nea_ts_
necrose939733necrose
neediest92611303neediest
negates83215843negates_
neglect1047363neglect
neist54628443ne__ist
nenes55329673ne_nes_
nerdiest92511163nerdiest
nerds65719253ne_rds_
nereid7312933ne_reid
nereis6315343ne_reis
nerts55924983ne_rts_
nerves94216193nerves_
nerviest11188833nerviest
nesses64718323nesses_
nest45548733n___est
netless739863netless
nettiest83112433nettiest
neumes83112623neumes_
neves87021873ne_ves_
newies91014073newies_
newness1035703newness
newsiest11107483newsiest
nicest82315663n_icest
nighest11310693nighest
nitres65519333nitres_
noblest93613563noblest
nosiest73415673nosiest
nudest74113833n_udest
numbest1138793numbest
oneriest8313443oneriest
palest83926223_palest
parent83230423_parent
pares77164483_pares_
peaces106324083peaces_
peages94321853peages_
peakiest143513003peakiest
pearliest1139363pearliest
pearls84715393pearls_
pears75138613pear_s_
peart76440753pear__t
peases85229473peases_
peatiest103118813peatiest
peeress939503peeress
peres76246643pe_res_
pertest9317043pertest
poorest9312773poorest
prest75736353__prest
purest84021933_purest
queerest1746273queerest
rares55247443_rares_
rawest93615063_rawest
readiest93719043readiest
reagent8716603reagent
reales64934123reales_
realist73225383realist
reared75930013reare_d
rearer64928913reare_r
rearers74323563rearers
rearmost1047263rearmost
rearms85114653rearms_
rearrests945313rearrests
rears54739653rear_s_
reaves94127573reaves_
reddest9311953reddest
redress82511873redress
reerect92915883reerect
reest54938093re__est
reforest1139963reforest
refresh1335453refresh
regreet83015953regreet
regress82711453regress
regret73723533regre_t
regrets83212923regrets
renest64529713re_nest
repress92712683repress
request16311023request
rerent63832453re_rent
rest46459843___rest
retest64028453re_test
retreat7317533retreat
revest94623603re_vest
safest95016603_safest
sagest74920263_sagest
sanest64426693_sanest
sayest94217743_sayest
scarcest12169173scarcest
scares85033003scares_
scariest101615953scariest
seamiest102715423seamiest
seared75232843seare_d
searer65432023seare_r
sears54744913sear_s_
secret8325063secre_t
secrets9311773secrets
securest1058583securest
sedatest9249393sedatest
seeress7311573seeress
seres55448893se_res_
severest11310323severest
sexiest142112223sexiest
shares95236413shares_
sharpest1339153sharpest
sheerest11310083sheerest
smartest10310183smartest
smeariest1138123smeariest
snares65329033snares_
sneakiest13176843sneakiest
sneeriest939313sneeriest
snellest839493snellest
sorest65028003_sorest
sourest7515713sourest
spares84834553spares_
sparsest1048823sparsest
squarest17338223squarest
stalest73720173stalest
stares66038753stares_
starets73515923starets
starkest1239723starkest
suavest10310623suavest
surest65026763_surest
tamest85721293_tamest
tares57456563_tares_
tartest72517533_tartest
teared75722153teare_d
tearer64822903teare_r
tearers75218233tearers
tearless848713tearless
tears55436463tear_s_
teases65426273teases_
tempest1139223tempest
tensest72713313tensest
terret63425623terre_t
terrets72913583terrets
tersest71713993tersest
tsarist7712253tsarist
tzarist1659103tzarist
unclearest12113823unclearest
undrest8313013undrest
uneases73316263uneases_
uneasiest946563uneasiest
unfairest1243563unfairest
unrest62918853_unrest
unwariest1246033unwariest
urares64519093urares_
vealiest112513203vealiest
veriest103719133veriest
verist93823893ve_rist
verset94327323ve_rset
verst84429373ve_r_st
wares88250583_wares_
wariest105122503_wariest
warmest123113033_warmest
wearer94319413weare_r
wearers104615903wearers
wearies103020233wearies_
wearish132310153wearish
wears86030303wear_s_
weaves123616373weaves_
weest85026773we__est
weirdest1244433weirdest
wettest10239363wettest
wrest84925433__wrest
yearend11285703yearend
yearns9509543yearns_
years84527673year_s_
yeast85327943yea__st

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340274206.36021073.4
3Display Results4204200.1532745.1
 (SQL Overall)1786914206.91925826.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.