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

532 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
dearest8361867(None) 
deadest93014881deadest
deafest112911511deafest
nearest73415841nearest
searest73322021searest
barest85327692_barest
clearest1038652clearest
dares66146702d_ares_
darkest122512622d_arkest
dearer74822802deare_r
dearies83526272dearies_
dearness939972dearness
dears65736882dear_s_
deaves105319532deaves_
decares102818532decares_
deepest10310442deepest
deffest14308802deffest
deforest1238792deforest
defrost1139552defrost
deftest112611712deftest
dekares122710872dekares_
demurest1137452demurest
densest83112472densest
depress10239872depress
detest74122842de_test
devest104418702de_vest
dewiest11312342dewiest
diarist8517112diarist
direst75024242d_irest
dourest8312942dourest
dreariest10229122dreariest
drest65530342d__rest
dwarfest1543472dwarfest
earnest7318732_earnest
featest102715112featest
headrest122910202headrest
leanest7415862leanest
leariest83117842leariest
meanest9315702meanest
merest84725112me_rest
neatest72516002neatest
peartest10311302peartest
rarest65725482_rarest
realest73322432realest
rearrest8311602rearrest
serest64831612se_rest
sparest94616422sparest
teariest82417262teariest
weakest1439002weakest
weariest112914792weariest
yarest95018912_yarest
addrest958633addrest
adeptest1145453adeptest
aeriest73924053aeriest
airest63825263_airest
anapest9311553anapest
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
bleariest1158843bleariest
bravest124211753bravest
brawest123810483brawest
cares77369183_cares_
caress85720263_caress
caret75360563_care_t
carets85330773_carets
ceases84427073ceases_
ceres75540013ce_res_
chares115631803chares_
chariest13315503chariest
cheapest1536073cheapest
claret84026573clare_t
clarets94111103clarets
cleanest10310293cleanest
coarsest1039163coarsest
crest74632693__crest
czarist18710223czarist
daces85030683d_aces_
daftest11248943daftest
dales66439743d_ales_
dames85435853d_ames_
dampest12411043dampest
dankest122611673dankest
darbs85323263d_arbs_
dare55848863d_are__
dared75935013d_are_d
darer65230793d_are_r
darers75921873d_arers
daresay1135433d_aresay
darks106727873d_arks_
darndest1067223d_arndest
darns66927893d_arns_
dart55857873d_ar__t
darts67635733d_arts_
dates65639153d_ates_
dazes155024143d_azes_
deadbeat1245803deadbeat
deaden83714323deade_n
deadens93410693deadens
deader84220473deade_r
deadeye1245163deadeye
deadliest1138183deadliest
deadness1039233deadness
deads75726913dea_ds_
deaerate9314173deaerate
deafen10389673deafe_n
deafens11317253deafens
deafer104114813deafe_r
deafish1438533deafish
deafness1236213deafness
deaired9411533deaire_d
deairs74013783deairs_
dealer74122143deale_r
dealers84118613dealers
deals65435343dea_ls_
dealt65234283dea__lt
deaned84620453deane_d
deanery1137613deanery
deans66131393dea_ns_
dear55343603dear___
dearie73319813dear_ie
dearly104615323dear_ly
dearth104212513dear_th
dearths11498843dearths
deary95826843dear__y
deash95617243dea__sh
deashes113313903deashes_
deaths105914443deaths_
deave95022333deave__
deaved114916553deave_d
debarks14388493debarks_
debarment1447793debarment
debars94218043debar_s_
debases103814133debases_
debates103718533debates_
debris93311493debris_
debyes1238103debyes_
decadent1249003decadent
decades113615513decades_
decanes103118913decanes_
decare93919153decare__
deceit93018213de_ceit
decent94023703de_cent
deciares11510633deciares_
declares11611313declares_
decrease1136563decrease
decree93117783decre_e
decreed112710253decreed
decreer10269123decreer
decrees102513123decrees
decrepit1345873decrepit
decries103319803decries_
decrypt1545703decrypt
deediest102912253deediest
deers64930523deer_s_
dees56356633de__es_
deet57356583de__e_t
deets65330243de__ets
defaces133213403defaces_
defames132812253defames_
defeat103817163de_feat
defect124816173de_fect
deferent122712873deferent
defers105116943defers_
defies104624053defies_
deflect13399973deflect
deforests1344373deforests
defrosts1244833defrosts
degames113312623degames_
degases93413103degases_
degrease1045413degrease
degree82814853degre_e
degreed10258883degreed
degrees92810723degrees
degust8310253de_gust
deices94119373deices_
deist64633593de__ist
deject164512843de_ject
dekare112811563dekare__
dekes105224453de_kes_
delates83526283delates_
deles65139253de_les_
delist74625053de_list
delves104917083delves_
demarks14339233demarks_
demast9517063de_mast
dement93825143de_ment
demerit10314993demerit
demes86032693de_mes_
demies94825803demies_
denars74621433denar_s_
denes65639723de_nes_
denies74729643denies_
dentist8316743dentist
deorbit1048173deorbit
depart94720563depar__t
departs104310683departs_
derat65044083de_r_at
derates84028893derates_
derats74625063derats_
derays105514253derays_
dere56845903de_re__
derms85022893de_rms_
derries83124623derries_
derris73615273derris_
descent102616293descent
desert72725493de_sert
deserts82513053deserts
desires81316133desires_
desist74818813de_sist
dessert82916453dessert
detect94217403de_tect
detent73624483de_tent
deters74724683deters_
detests83711743de_tests
detract101414633detract
deuces94015513deuces_
devests114410473de_vests
dewars105117073dewar_s_
dewaxes18297843dewaxes_
dewless1137473dewless
dexes135224513de_xes_
dexies145018343dexies_
dialect101210263dialect
dialist8517763dialist
diaries83321953diaries_
diarists9410363diarists
diciest103316523diciest
digest84019623d_igest
digress938323digress
dimmest1249253dimmest
direct93817333d_irect
divest106820073d_ivest
doest65829523d__oest
dopiest103315993dopiest
dotiest83717453dotiest
doziest174012473doziest
drabbest13295663drabbest
drakes114715863drakes_
drapes95419653drapes_
dreamiest12227223dreamiest
drearies92313413drearies_
drears74614253drear_s_
dress65319833d__ress
driest74722753d_riest
dryest104811123d_ryest
dualist8614053dualist
dullest8312633dullest
dumbest1238743dumbest
dunnest83312263dunnest
dures65635923d_ures_
duress74712063d_uress
durst66125173d_ur_st
dwarfs13436273dwarfs_
dwarves1434463dwarves_
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_
edgiest92310353edgiest
eeliest73516473eeliest
eeriest73620673eeriest
egest65222343_e_gest
egress73310433_egress
egret63327313_egre_t
egrets72712243_egrets
eldest72912683_eldest
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
gamest94919923_gamest
gayest104314333_gayest
geared85317743geare_d
gearless937373gearless
gears64628693gear_s_
geest64829613ge__est
genres75515623genres_
gerent73223093ge_rent
glares75518863glares_
glariest92012523glariest
gravest114011633gravest
grayest11489363grayest
greatest939863greatest
haeres94017033haeres_
halest94823273_halest
hardest113118413_hardest
hares86255543_hares_
harvest132112753_harvest
headiest123015553headiest
headrests13245023headrests
headset11312603headset
hearer94323643heare_r
hearers104319783hearers
hears86737373hear_s_
hearse94114273hear_se
hearsed113811403hearsed
hearses104414533hearses
heart85440743hear__t
heartiest12311103heartiest
hearts96218943hearts_
heaves124120303heaves_
heaviest143210443heaviest
heiress1036813heiress
heppest14228143heppest
hereat93527413he_reat
heres86245903he_res_
heresy125011233he_resy
hoariest11312883hoariest
hoarsest1137133hoarsest
idealess935653idealess
idealist9310653idealist
ideates8313733ideates_
imaret81121233imare_t
imarets9138643imarets
imprest11310203imprest
inanest72115363inanest
iratest7312483iratest
karst97228993_kar_st
keenest11410963keenest
lamest84722763_lamest
lares54852633_lares_
largest83715103_largest
latest63822703_latest
laxest134913363_laxest
leadiest93314983leadiest
leafiest113410883leafiest
leakiest123212793leakiest
learns65513743learns_
learnt64019253lear_nt
lears55938733lear_s_
leases65428113leases_
least56134883lea__st
leaves94222383leaves_
leaviest112910813leaviest
leeriest83112883leeriest
leftest10269463leftest
lewdest1136283lewdest
mares76457633_mares_
mayest114614793_mayest
mealiest102215973mealiest
meatiest102816793meatiest
meekest1336893meekest
meres75143573me_res_
merriest10311473merriest
metres85121563metres_
metrist9317063metrist
nares55544153_nares_
neared75119803neare_d
nearer64618893neare_r
nearliest949363nearliest
nearness838313nearness
nears55529423near_s_
newest9314213ne_west
palest83926223_palest
parent83230423_parent
pares77164483_pares_
peaces106324083peaces_
peages94321843peages_
peakiest143512993peakiest
pearliest1139353pearliest
pearls84715393pearls_
pears75138613pear_s_
peart76440753pear__t
peases85229473peases_
peatiest103118803peatiest
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_
scariest101615943scariest
seamiest102715413seamiest
seared75232843seare_d
searer65432023seare_r
sears54744913sear_s_
secret8325063secre_t
secrets9311773secrets
securest1058583securest
sedatest9249393sedatest
seeress7311573seeress
seres55448893se_res_
severest11310323severest
sexiest142112223sexiest
shares95236413shares_
sharpest1339143sharpest
sheerest11310083sheerest
smartest10310183smartest
smeariest1138113smeariest
snares65329033snares_
sorest65028003_sorest
sourest7515713sourest
spares84834553spares_
sparsest1048813sparsest
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
undrest8313013undrest
unrest62918853_unrest
urares64519093urares_
vealiest112513203vealiest
veriest103719133veriest
verist93823893ve_rist
verset94327323ve_rset
verst84429373ve_r_st
wares88250583_wares_
wariest105122503_wariest
warmest123113033_warmest
wearer94319403weare_r
wearers104615903wearers
wearies103020223wearies_
wearish132310153wearish
wears86030303wear_s_
weaves123616373weaves_
weest85026773we__est
weirdest1244433weirdest
wettest10239363wettest
wrest84925433__wrest
yearend11285703yearend
yearns9509543yearns_
years84527673year_s_
yeast85327943yea__st

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340275326.75019855.9
3Display Results5325320.1862860.2
 (SQL Overall)1786915327.09225196.1
 
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.