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

515 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
nereid731292(None) 
nereids838741nereids
nereis6315341nereis
aeried74221862aeried
aneroid8314002aneroid
cered85227442cere_d
cervid1239322cervid
energid948302energid
fervid1337512fervid
herein93717792herein
jereed144012062jereed
jerid132316422jer_id
jerrid14259142jerrid
neared75119802neare_d
need54934152ne_e_d
negroid9108892negroid
nerd56624942ner__d
nereides938502nereides
nerved104111682nerved
neuroid81110302neuroid
nevoid1098792nevoid
pereia85217982pereia
reread71715432reread
sered65737292sere_d
serein63318462serein
verbid122311312verbid
acred87126353acre_d
acrid86920103acr_id
aerie54634603aer_ie
aerier64823153aerier
aeries64737783aeries
afraid1049723afraid
agreed84712503agreed
aired66032923aire_d
android9311513android
aneared8512743aneare_d
aneled74719273anele_d
anergia847363anergia
anergic1048103anergic
aneroids9310203aneroids
angered93013473angere_d
areic73219393_areic
arid57642713_ar_id
aroid65428343_aroid
aurei54821863aurei_
bared85144483bare_d
bedrid1039943bedrid
beedi8711663be_edi
behead1239923behead
beheld1236413beheld
belied95022163belied
bereft114317303bereft
beret74946363bere_t
berets85822523berets
berlin83116373berlin
bermed115217723bermed
berried103714043berried
bored85034303bore_d
braid85822263_braid
bread85523113_bread
bred75130973_bre_d
breed85526693_breed
buried94822373buried
cared86050093care_d
caried94528693caried
cebid104314073ce_bid
ceboid11310653ceboid
ceded96118553cede_d
cepheid1545433cepheid
cerci93716393cerci_
cercis104614493cercis
cere66741473cere__
cereal8315833cereal
ceres75540013cere_s
cereus85215523cereus
ceria75125353cer_ia
ceric94023093cer_ic
cervix1865163cervix
clerid9312413cler_id
cored85044223core_d
corvid12310473corvid
cred76530883_cre_d
creed85727393_creed
cried84624283_cried
cured85932133cure_d
dared75935013dare_d
deceit93018213deceit
decreed112710253decreed
decried112612853decried
deed65340903de_e_d
defend113910493defend
defied115016383defied
degreed10258883degreed
deked115718533deke_d
delead84112343delead
deled75326543dele_d
denied84318633denied
depend103510923depend
derail74218813derail
dere56845903dere__
deride84420033der_ide
dermic114511913dermic
dermis94717163dermis
dermoid1138523dermoid
derris73615273derris
desmid1048363desmid
devein1039143devein
devoid1189363devoid
dewed105020303dewe_d
dread74419023_dread
dreed75222843_dreed
dreidl835233_dreidl
dried75321383_dried
droid74218543_droid
druid74111323_druid
dured75025403dure_d
eared65139503eare_d
eerie55228533eer_ie
eerier64320023eerier
eked96718023_eke_d
emend86214893_emend
emeroid101511183emeroid
ended74421263ende_d
energids1045583energids
ennead736253ennead
entered82718883entere_d
enured73315333enure_d
envied1038833envied
equid154610323_equid
ere36352773_ere__
erect74129333_erect
erred65915673_erred
ervil8310303_ervil
exed125420593_exe_d
eyed86623233_eye_d
eyelid1038443_eyelid
fared95842343fare_d
feared106320433feare_d
feed84538903fe_e_d
felid94717173fe_lid
fere76342233fere__
feres86038183fere_s
feria85922713fer_ia
ferlie92814053ferlie
fermi103914163fermi_
fermis114313503fermis
ferric1139993ferric
ferried113411523ferried
feted94420933fete_d
fetid93715983fe_tid
feued94715663feue_d
fired94829743fire_d
forbid123312433forbid
fordid113512053fordid
foredid1238503foredid
freed95223543_freed
fremd115010323_fremd
fried95322913_fried
geared85317743geare_d
geed65435503ge_e_d
gelid74916983ge_lid
geoid74215763ge_oid
gerbil938343gerbil
gerent73223093gerent
gerund836163gerund
gored75227083gore_d
greed75125693_greed
grid65829613_gr_id
gyred105114093gyre_d
hared95742183hare_d
heed86437603he_e_d
heired103813043heire_d
hemoid12313513hemoid
herald10311343herald
herbed123513453herbed
herd84933063her__d
herded114215643herded
herdic123112303herdic
here76447103here__
hereat93527413hereat
hereby14468333hereby
hereof123212373hereof
hereon93914363hereon
heres86245903here_s
heresy125011233heresy
heretic12314833heretic
hereto9313693hereto
hermit11519443hermit
hernia9312293hernia
heroic113516923heroic
heroin94420593heroin
herried113514453herried
hewed125619433hewe_d
hexed165615763hexe_d
hired95226263hire_d
horrid10311563horrid
inbred93010403inbre_d
inbreed10267643inbreed
inertia7410203inertia
inhered11313163inhere_d
intrepid1145363intrepid
inured73114813inure_d
ired55131873_ire_d
irid55927173_ir_id
jeed125428503je_e_d
jeered143912793jeered
jereeds15326383jereeds
jeremiad1853343jeremiad
jerids142810943jer_ids
jerked18479593jerked
jerkin17258113jerkin
jerreed1535203jerreed
jerrids15277743jerrids
jewed165114833jewe_d
juried144212443juried
keloid11812623keloid
kerbed13339693kerbed
kerfed14358223kerfed
kermis124012393kermis
kerned114112923kerned
kerria10339913kerria
keyed1369383keye_d
kneed104612053kne_e_d
leered73816223leered
legend837693legend
leveed104111373leveed
levied104111433levied
lured65427493lure_d
lurid64618973lur_id
meed74934703me_e_d
meloid9616003meloid
mere67244443mere__
merely111312583merely
merer75126233mere_r
meres75143573mere_s
merest84725113merest
merged104214943merged
merit7339183mer_it
merlin83916683merlin
mermaid1297853mermaid
meted85424433mete_d
metred95315143metre_d
mewed115218013mewe_d
mired85729223mire_d
morbid112511463morbid
mured85726703mure_d
murein8311763murein
murid84520583mur_id
nacred95212493nacre_d
naevoid1194593naevoid
naked105320853nake_d
naled65525053nale_d
named85223063name_d
narcein936293narcein
nard56634453nar__d
nares55544153nare_s
naric76824173nar_ic
naris55735293nar_is
narked114116743narked
navaid1037653navaid
nearer64618893neare_r
nearest73415843nearest
nearside944913nearside
necked134715063necked
nee36657783ne_e__
needed84114443needed
needs65719633ne_eds
needy94614693ne_edy
neem67328083ne_e_m
neems77316293ne_ems
neep65728313ne_e_p
neeps75617883ne_eps
negroids10116323negroids
neif75429493n__eif
nellie63614813nellie
nemesis937373nemesis
nene45932063nene__
nenes55329673nene_s
neoned7311483neoned
nepeta837893nepeta
nerdier83110353nerdier
nerdish1137103nerdish
nerds65719253ner_ds
nerdy95014703ner_dy
neritic91314333neritic
nerol51017813ner_ol
neroli61111153neroli
nerolis71012773nerolis
nerols6914883nerols
nerts55924983ner_ts
nertz145117453ner_tz
nerve86617373ner_ve
nerves94216193nerves
nervier10298833nervier
nervily1336863nervily
nervine102510623nervine
nerving112910823nerving
nervy114610863ner_vy
nested74720063nested
netted74118713netted
neumic1036853neumic
neve76224833neve__
never86218643neve_r
neves87021873neve_s
nevi75116423ne_vi_
newbie11135413newbie
newel86114133newe_l
newels93710823newels
newer85717463newe_r
newest9314213newest
newie81813483ne_wie
newies91014073newies
newsie9138213newsie
nided75920873nide_d
nisei54214353nisei_
niseis63512023niseis
nitid61817833n_itid
nitrid72812233nitrid
nixed135714223nixe_d
nordic939473nordic
nori47133143nor_i_
noria55722183nor_ia
noris54928273nor_is
normed95014543normed
nosed65524553nose_d
noted65123843note_d
nuked104014183nuke_d
nurd56224343nur__d
nurled74016233nurled
nursed74514663nursed
oared65030653oare_d
onerier7311613onerier
oread64619603_oread
oreide7311673_oreide
overbid132710273overbid
overdid12199173overdid
overed102216623overe_d
pared86946763pare_d
peed76239183pe_e_d
peered93819483peered
peerie83617893peerie
peptid112712373peptid
peracid12312993peracid
percoid12312313percoid
perdie94718513perdie
pere66450263pere__
perea75026443pere_a
pereion9312053pereion
pereon83517453pereon
peres76246643pere_s
perfidy1635263perfidy
peri65636973per_i_
peril75425953per_il
period9314983period
peris75537073per_is
perked134617683perked
permed115217343permed
permit10321683permit
pernio8513143pernio
pernod9310453pernod
peroxid17310263peroxid
perpend12259343perpend
pored85234513pore_d
prebid113512843prebid
preed85128113_preed
pried84426863_pried
pureed95017803pureed
queried1738683queried
raid55243073__raid
rared65738323rare_d
read55942533__read
reared75930013reare_d
rebid85121363re_bid
rebred95816353rebre_d
rebreed104611073rebreed
red46755803__re_d
redd66323173__redd
reded74829113rede_d
redid74922393re_did
redried93714893redried
reed55549623__reed
refed93921923refe_d
refeed104717623refeed
refried113513873refried
rei35647253__rei_
reif76937653__reif
rein46040893__rein
reis45343233__reis
relaid75518443relaid
relend76116453relend
relied74926233relied
remend95216553remend
rend56136573__rend
repaid94716323repaid
rereads81512293rereads
reremind1147513reremind
rerent63832453rerent
rerig64018483rer_ig
resaid74517083resaid
reseed74823293reseed
resend75016773resend
resid64124093re_sid
retied75924983retied
retread849003retread
retried84419153retried
rewed95425453rewe_d
reweld103711113reweld
rid46754623__r_id
sclereid1145363sclereid
screed95718923screed
scried95817303scried
seared75232843seare_d
seed55549483se_e_d
serai56830163serai_
serail64222673serail
serais64326133serais
sere46153473sere__
sereins73716113sereins
serene63522353serene
serer55935503sere_r
seres55448893sere_s
serest64831613serest
serged84118763serged
series64540973series
serif84132133ser_if
serin55434443ser_in
serried82513963serried
served104616813served
sewed95325163sewe_d
sexed136618543sexe_d
shred98125613shre_d
shrewd136810773shrewd
sired66134283sire_d
snared74824553snare_d
sneered83113973sneered
snored74819543snore_d
sordid83411163sordid
sored66141783sore_d
spread9312533spread
steroid81314863steroid
synergid1344573synergid
tared69340053tare_d
teared75722153teare_d
teed55439263te_e_d
teiid6312533te_iid
tepid8314313te_pid
terai53525483terai_
terais64023513terais
terbia8311153terbia
terbic10410963terbic
terebic1137983terebic
teredo7310783teredo
terete6319333terete
termed94816703termed
territ63421373territ
tewed94718533tewe_d
therein102310353therein
theroid11313403theroid
thread105011093thread
tiered73613973tiere_d
tineid74412023tineid
tired65228903tire_d
toroid7416013toroid
torpid9310913torpid
torrid7311853torrid
tread64821703_tread
treed65626733_treed
trend64817453_trend
trepid9310083trepid
tried65026913_tried
turbid979713turbid
turgid868013turgid
tyred95816433tyre_d
unbraid1037183unbraid
unbred92613303unbre_d
underbid12108203underbid
underdid11128133underdid
undried92314613undried
unfreed11510123unfreed
unread73412673unread
untread857413untread
untried82615853untried
ureic74514463_ureic
ureide7310363_ureide
ursid6311483_ursid
varied104817863varied
veered103612743veered
verbids13259203verbids
verdin103113023verdin
verged114815153verged
verier94620963verier
vermeil1285223vermeil
vermin113414523vermin
vermis114214963vermis
vernix1636633vernix
versed104515513versed
vespid1246083vespid
vexed165713113vexe_d
virid94116043vir_id
viroid10411523viroid
wared96339873ware_d
wearied112911803wearied
weed85637513we_e_d
were76238333were__
weregild1342823weregild
wergeld1233183wergeld
wergild1234043wergild
wherein13216593wherein
wired95327643wire_d
wried95518563_wried
xeric144315663xer_ic
yearend11285703yearend
yerked14509373yerked
zebroid1936463zebroid
zeroed16409413zeroed

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127165155.14021929.2
3Display Results5155150.1732976.9
 (SQL Overall)1786915155.45332769.3
 
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.