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
nerolis7101277(None) 
neroli61111151neroli_
nerols6914881nerol_s
enrolls7108092enrolls
enrols61213382enrol_s
necrosis1048882necrosis
negronis947262negronis
nereis6315342ner_eis
nerol51017812nerol__
neurosis848842neurosis
rerolls739942rerolls
xerosis14249662xerosis
acerolas1048053acerolas
aerobes9311493aerobes
aerobia939463aerobia
aerobic11310213aerobic
aerobics1246833aerobics
aerolite8315053aerolite
aerolites9312583aerolites
aerolith1149833aerolith
aeroliths1245643aeroliths
aiolis6316843_aiolis
anemosis10148073anemosis
aneroid8314003anero_id
aneroids9310203aneroids
areolas71013863areolas
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
eroses65327053_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
heroes94923823hero_es
heroic113516923hero_ic
heroics122912003heroics
heroin94420593hero_in
heroins103518013heroins
heroism12311013hero_ism
herons94820543hero_ns
heros84930863hero__s
kenosis11369003kenosis
kermis124012393ker_mis
ketols104210763ketol_s
ketosis11429733ketosis
meiosis939023meiosis
merisis93213173merisis
merles85322763mer_les
merlin83916683mer_lin
merlins93015813mer_lins
merlons93311273merlons
merlots92710123merlots
merls77423903mer_l_s
meropia1149613meropia
meropias1249963meropias
meropic13310263meropic
metols84115773metol_s
narcosis10388043narcosis
naris55735293nar__is
nebulas957583nebulas
nebulise1045743nebulise
necropolis1455273necropolis
necroses10310563necroses
necrotic12310043necrotic
needles83211563needles
negroid9108893negro_id
negroids10116323negroids
negroni846833negroni_
nellie63614813ne_llie
nellies73418723ne_llies
nemesis937373nemesis
neolith1068783ne_olith
neoliths1144933ne_oliths
neons55818683ne_o_ns
nephrosis1445093nephrosis
nepotic11310563nepotic
nepotism1246483nepotism
nepotist1059233nepotist
nerdish1137103ner_dish
nerds65719253ner__ds
nereid7312923ner_eid
nereids838743nereids
neritic91314333neritic
nerts55924983ner__ts
nerves94216193ner_ves
nervily1336863nervily
nervous1037143nervous
nervules1145013nervules
nestles73015463nestles
netops839213neto_ps
nettles73214083nettles
neuritis848493neuritis
neuroglia1054033neuroglia
neuroglias1153943neuroglias
neuroid81110303neuro_id
neuromas1046633neuromas
neurones839673neurones
neuronic1049013neuronic
neurons7410443neuro_ns
neuroses8310153neuroses
neurotic1039693neurotic
neurotics1147363neurotics
neurulas844833neurulas
nevoid1098793nevo_id
newels93710823newel_s
nicols8810243nicol_s
nitrolic1046813nitrolic
noils55024333n__oils
nolos54423353n__olos
noris54928273n__oris
nurls55519683nur_l_s
onerous7312973onero_us
ooralis7312553ooralis
paroles95025883paroles
parols84722613parol_s
pergolas1158233pergolas
perils84121853peril_s
peris75537073per__is
peroxid17310273peroxid
peroxids1837453peroxids
petrolic1249693petrolic
petrols92913083petrol_s
polis74731163__polis
proles84627203_proles
prolix1538683_prolix
pyrolas1239863pyrolas
pyrosis12411653pyrosis
reboils94111723reboils
recoils93814873recoils
refolds11298953refolds
remolds10299703remolds
reoils64516873re_oils
repolish1347933repolish
repolls939053repolls
reroll6412683rerol_l
reroofs1037943reroofs
resoles73823653resoles
revolts1038893revolts
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
xeroses143612823xeroses
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.420425454.8
2DLD Change Limit1340272147.31318327.2
3Display Results2142140.0802675.0
 (SQL Overall)1786912147.81322871.0
 
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.