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

214 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
nerolis7101278(None) 
neroli61111161neroli_
nerols6914891nerol_s
enrolls7108092enrolls
enrols61213382enrol_s
necrosis1048892necrosis
negronis947272negronis
nereis6315342ner_eis
nerol51017812nerol__
neurosis848852neurosis
rerolls739942rerolls
xerosis14249672xerosis
acerolas1048053acerolas
aerobes9311493aerobes
aerobia939473aerobia
aerobic11310213aerobic
aerobics1246833aerobics
aerolite8315053aerolite
aerolites9312593aerolites
aerolith1149833aerolith
aeroliths1245653aeroliths
aiolis6316843_aiolis
anemosis10148073anemosis
aneroid8314013anero_id
aneroids9310203aneroids
areolas71013873areolas
areoles71016953areoles
bedrolls1144673bedrolls
beholds1336423beholds
berlin83116373ber_lin
berlins93216013ber_lins
beryls11107883beryl_s
broils84114173_broils
caroli85918233caroli_
carols85124983carol_s
carolus94612603carolus
ceilis85413743ce_ilis
ceorlish1345383ceorlish
ceorls848163ceorl_s
cercis104614493cer_cis
ceros74726073cero__s
cerotic11415063cerotic
cerous85821203cero_us
creoles9913323creoles
creolise1037863creolise
delis64928543de__lis
demolish1447833demolish
depolish1446943depolish
derails84216393derails
dermis94717163der_mis
derris73615273der_ris
drolls75312393_drolls
enfolds11136253enfolds
enokis103010273_enokis
enolic8413353_enolic
enols54718403_enol_s
enosis63816423_enosis
enrobes92211113enrobes
enrol51014283enrol__
enroll61110073enrol_l
enroots738713enroots
entoils7810733entoils
envois988703envo_is
erodes74819883_erodes
eros45238453_ero__s
eroses65327063_eroses
erotic82620273_erotic
erotics91914153_erotics
erotism9312303_erotism
ervils948773_ervils
ferals94216643feral_s
ferlie92814053fer_lie
ferlies103216693fer_lies
fermis114313503fer_mis
ferulas103110753ferulas
ferules103112723ferules
frolic1149203_frolic
frolics1236833_frolics
gerbils1037303gerbils
heralds1137713heralds
herls85226433her_l_s
heroes94923833hero_es
heroic113516923hero_ic
heroics122912003heroics
heroin94420593hero_in
heroins103518013heroins
heroism12311013hero_ism
herons94820543hero_ns
heros84930863hero__s
kenosis11369003kenosis
kermis124012403ker_mis
ketols104210763ketol_s
ketosis11429733ketosis
meiosis939023meiosis
merisis93213173merisis
merles85322763mer_les
merlin83916693mer_lin
merlins93015823mer_lins
merlons93311273merlons
merlots92710123merlots
merls77423903mer_l_s
meropia1149623meropia
meropias1249973meropias
meropic13310273meropic
metols84115773metol_s
narcosis10388053narcosis
naris55735293nar__is
nebulas957583nebulas
nebulise1045743nebulise
necropolis1455293necropolis
necroses10310573necroses
necrotic12310053necrotic
needles83211563needles
negroid9108903negro_id
negroids10116333negroids
negroni846843negroni_
nellie63614813ne_llie
nellies73418723ne_llies
nemesis937373nemesis
neolith1068783ne_olith
neoliths1144933ne_oliths
neons55818683ne_o_ns
nephrosis1445103nephrosis
nepotic11310563nepotic
nepotism1246483nepotism
nepotist1059233nepotist
nerdish1137103ner_dish
nerds65719253ner__ds
nereid7312933ner_eid
nereids838743nereids
neritic91314333neritic
nerts55924983ner__ts
nerves94216193ner_ves
nervily1336863nervily
nervous1037143nervous
nervules1145013nervules
nestles73015463nestles
netops839223neto_ps
nettles73214083nettles
neuritis848493neuritis
neuroglia1054043neuroglia
neuroglias1153953neuroglias
neuroid81110313neuro_id
neuromas1046633neuromas
neurones839683neurones
neuronic1049023neuronic
neurons7410453neuro_ns
neuroses8310163neuroses
neurotic1039703neurotic
neurotics1147373neurotics
neurulas844833neurulas
nevoid1098803nevo_id
newels93710823newel_s
nicols8810243nicol_s
nitrolic1046813nitrolic
noils55024333n__oils
nolos54423353n__olos
noris54928273n__oris
nurls55519683nur_l_s
onerous7312973onero_us
ooralis7312553ooralis
paroles95025893paroles
parols84722613parol_s
pergolas1158233pergolas
perils84121853peril_s
peris75537073per__is
peroxid17310283peroxid
peroxids1837453peroxids
petrolic1249693petrolic
petrols92913083petrol_s
polis74731163__polis
proles84627203_proles
prolix1538683_prolix
pyrolas1239863pyrolas
pyrosis12411653pyrosis
reboils94111723reboils
recoils93814873recoils
refolds11298953refolds
remolds10299703remolds
reoils64516873re_oils
repolish1347933repolish
repolls939053repolls
reroll6412683rerol_l
reroofs1037943reroofs
resoles73823653resoles
revolts1038903revolts
roils54826793__roils
roles56747983__roles
rolfs84817123__rolfs
rolls55326233__rolls
rotis56327063__rotis
scrolls938063scrolls
serails73318363serails
serais64326133ser_ais
serosas7312663serosas
serous65023563sero_us
serows96016393sero_ws
sorosis72611973sorosis
sterols7313443sterol_s
strolls739183strolls
terais64023513ter_ais
trellis739873trellis
trois57226093_tro_is
trolls64613943_trolls
unerotic1049193unerotic
unrolls797793unrolls
verglas1137813verglas
vermis114214963ver_mis
virosis1039023virosis
xeroses143612833xeroses
xerotic16410863xerotic
xeroxes13246443xeroxes
zeroes154314343zero_es
zeros144918113zero__s

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.423422437.4
2DLD Change Limit1340272146.81019680.9
3Display Results2142140.0802675.0
 (SQL Overall)1786912147.31324434.7
 
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.