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

144 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
nemesis93737(None) 
emesis84712621_emesis
nemeses948661nemeses
anemosis10148072anemosis
ecesis84611202_ecesis
emeses86114962_emeses
genesis82510822genesis
mimesis1137322mimesis
nereis6315342nere_is
noesis6311442n_oesis
telesis7310792telesis
tmesis8529792_tmesis
agenesis938043agenesis
anamnesis1144023anamnesis
anemoses10159433anemoses
anthesis11312503anthesis
anuresis846973anuresis
aphesis12610513aphesis
ascesis938373ascesis
askesis1136123askesis
auxesis1445443auxesis
behests1235953behests
bejesus1643693bejesus
bemeans1148743bemeans
bemists113410713bemists
bemuses1139293bemuses
cements112714223cements
centesis1058143centesis
cyesis1148573_cyesis
demasts1089223demasts
demeans1039723demeans
dements103016623dements
demerit10314993demerit
demerits11310763demerits
demes86032693deme__s
demesne1035573demesne
demesnes1137083demesnes
demises103719563demises
demoses103815833demoses
detests83711743detests
devests114410473devests
dieresis956853dieresis
diesis74013493_diesis
ecesic10369223_ecesic
egests74411253_egests
elemis8312383_elemis
emeers83314183_emeers
emends95711433_emends
emeries91620023_emeries
emes65434663_eme__s
emetic10614453_emetic
emetics11610723_emetics
emetin8613463_emetin
emetins9812653_emetins
emeus76913333_eme_us
enmesh1134893enmes_h
enmeshes1345343enmeshes
enosis63816423_enosis
entasis73012573entasis
enuresis845493enuresis
exegesis1643643exegesis
femes105626223feme__s
geests75912163ge_ests
geneses82613523geneses
hemes105031083heme__s
heresies11312703heresies
kenosis11369003kenosis
kermess13396223kermes_s
ketosis11429733ketosis
kinesis11259593kinesis
kneesies1245543kne_esies
meiosis939023meiosis
memes94927703meme__s
memetics1447803memetics
merisis93213173merisis
mesas76823203__mesas
mesic93617863__mesic
mess65932433__mes_s
metis75025903__metis
mimeses1139073mimeses
namers84517333name_rs
names74833363name__s
necrosis1048893necrosis
needs65719633ne_e_ds
neems77316293ne_e_ms
neeps75617883ne_e_ps
neguses837933neguses
nemas75321573nem__as
nematic111714003nematic
nenes55329673nene__s
nepetas935943nepetas
nereid7312933nere_id
nereids838743nereids
nerolis71012783nerolis
ness45526563n__es_s
nesses64718323ne_sses
nests55728003n__ests
netless739863netles_s
neumes83112623neume__s
neurosis848853neurosis
neves87021873neve__s
newels93710823newe_ls
newest9314213newes_t
newness1035703newnes_s
newsie9138223ne_wsie
newsies101310393ne_wsies
nexuses1436743nexuses
niseis63512023nise_is
nomes74933123nome__s
nomisms11268743nomisms
numeric1158193numeric
numerics1266283numerics
oneness7512143onenes_s
osmosis976573osmosis
paresis93315093paresis
pheresis1377633pheresis
recess8314263reces_s
reests64618893re_ests
remedies11310553remedies
remeets93712413remeets
remelts93511493remelts
remends105013033remends
remises93423483remises
remiss84216353remis_s
renests74014213renests
retests73813853retests
revests104413743revests
sememes11109203sememes
sememic1336503sememic
semens84616973seme_ns
semes75731583seme__s
semiosis1059873semiosis
semis74623533sem__is
semises93916553semises
senseis73310643senseis
sepsis83011293se_psis
syneresis1244843syneresis
synesis1039163synesis
teleses7313123teleses
tempests1234443tempests
thesis94913733_thesis
tmeses85712243_tmeses
xerosis14249673xerosis
zymosis21487493zymosis

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 Limit1340271446.01622278.4
3Display Results1441440.0632285.7
 (SQL Overall)1786911446.48527554.5
 
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.