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

184 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
pyemia133755(None) 
pyaemia1445731pyaemia
pyemias1436801pyemias
pyemic1537891pyemic
anemia82613572anemia
premie103617992premie
premix173710332premix
pyaemias1545062pyaemias
pyaemic1645872pyaemic
pyrexia19225462pyrexia
pyuria1136952pyuria
uremia82910892uremia
abelia83114403abelia
acedia9310393acedia
aecia73819283_aecia
alexia132910463alexia
amia66836903__amia
anaemia959803anaemia
anemias92512143anemias
anemic102713693anemic
aphelia1249423aphelia
apteria9312913apteria
bema85825253_bem_a
bemix165011453_bemix
bohemia1446363bohemia
ceria75125353_ceria
chemic153012093chemic
copremia1445253copremia
coremia11310363coremia
cyesis1148573cyesis
cyma116715843cy_m_a
demic105119193_demic
demit84832303_demit
edema8610553edem_a
elemi7312503elemi_
elemis8312383elemis
emic86422753__emic
emir65918703__emir
emit65438423__emit
empyema1642643empyem_a
empyemic1943313empyemic
enema7612743enem_a
eyelid1038443eyelid
feria85922713_feria
gemma106311773_gemma
gremial1039153gremial
gynecia1384233gynecia
haemic133210083haemic
haemin113412663haemin
hemic125718623_hemic
hemin103620933_hemin
hydria13227903hydria
hyena11810253hye_na
hyenic1438723hyenic
hymenia1546393hymenia
hyphemia2146133hyphemia
kalmia1238893kalmia
lamia75324323_lamia
lemma94811033_lemma
media84721713_media
mycelia1444843mycelia
myelin1138973myelin
myoma1239273myom_a
myopia13318443myopia
nema65522523_nem_a
obelia8329453obelia
paella8410913paella
pallia83015593pallia
pampa114913423p_ampa
pea56657243p_e__a
peerie83617893peerie
peewit111110903peewit
pein65834943p_e_in
pekin111514423p_ekin
pembina1345223p_embina
pemican1348163p_emican
penial84120893p_enial
penis75129323p_enis
penna74520203p_enna
pennia84412973pennia
pepla9312863p_epla
perea75026443p_erea
pereia85217983pereia
peri65636973p_eri_
peril75425953p_eril
peris75537073p_eris
permian112612283permian
permit10321683permit
petit74332653p_etit
pewit104622793p_ewit
phenix1837133phenix
phobia13278603phobia
pia56848033p___ia
pieta75421753pie_ta
pima85428653p_im_a
plea66830603ple__a
pleiad947833ple_iad
plena75816393ple_na
pleura837533pleura
pneuma1035263pneuma
podia8415283p_odia
poem86225773poem__
poems95715553poem_s
poetic10416843poetic
polemic13311253polemic
pommie123710503pommie
prebid113512843prebid
precis103416703precis
predial103815413predial
preemie11310563preemie
prefix18356853prefix
prelim10311423prelim
preman104117453preman
premeal11310523premeal
premed114617763premed
premen105017803premen
premier113515633premier
premies113823063premies
premise113818553premise
premiss113513813premiss
premium13310363premium
premixt183510663premixt
presa74319043pre_sa
prima95019343prim_a
primi95017403primi_
proemial1249183proemial
pterin81014153pterin
puma85424123p_um_a
pya87023753py___a
pye86432503pye___
pyes95528993pye__s
pygidia1444193pygidia
pygmean1542223pygmean
pygmies15205673pygmies
pygmoid1644533pygmoid
pygmy16334223pygm_y
pyic116915823py__ic
pyin96823233py__in
pyjama20303483pyjama
pyknic1734893pyknic
pyoid11513763py_oid
pyosis114012123pyosis
pyramid1547513pyramid
pyretic143210783pyretic
pyrexial20234973pyrexial
pyrexias20224993pyrexias
pyrexic21235353pyrexic
pyric123815073py_ric
pyrola1139003pyrola
pyurias1236713pyurias
pyxidia2043843pyxidia
pyxie17359363py_xie
pyxis17458633py_xis
redia65524483_redia
reemit8717223reemit
remit75737223_remit
remix145916553_remix
retia55326113_retia
sapremia1245203sapremia
semi65127223_semi_
semina8915573_semina
semis74623533_semis
sepia75318673_sepia
splenia948313splenia
stemma10328133stemma
taenia6313193taenia
telia55821143_telia
tenia55324483_tenia
toxemia1644873toxemia
ulema7109713ulem_a
uraemia946503uraemia
uredia73610063uredia
uremias9249503uremias
uremic103410513uremic
viremia1246083viremia
xenia124814773_xenia
yea66445753_ye__a
yenta83917043_yenta
yerba101010763_yerba
yeti75823213_yeti_
yetis85418393_yetis
yomim12510083_yomim
zamia165115213_zamia
zoecia1735553zoecia

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.406440125.6
2DLD Change Limit1127161845.39320900.4
3Display Results1841840.0603066.7
 (SQL Overall)1786911845.85930498.5
 
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.