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 “pyemias” 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
pyemias143680(None) 
pyaemias1545061pyaemias
pyemia1337551pyemia_
anemias92512142anemias
premies113823062premies
premiss113513812premiss
pyaemia1445732pyaemia_
pyemic1537892pyemi_c
pygmies15205672pygmies
pyrexias20224992pyrexias
pyurias1236702pyurias
uremias9249502uremias
abelias93213563abelias
acedias1039763acedias
alexias14249793alexias
amias75831463__amias
anaemias1069193anaemias
anemia82613573anemia_
bemas96424283_bem_as
bohemias1545983bohemias
cerias83321973_cerias
chemics16349573chemics
copremias1545133copremias
cyesis1148573cyesi_s
cymas126417883cy_m_as
demies94825803_demies
demits94918073_demits
edemas9310503edem_as
elemis8312383elemi_s
emirs76116153__emirs
emits75421463__emits
empyemas1742223empyem_as
enemas8812003enem_as
enemies9313693enemies
eyelids1135943eyelids
ferias95020393_ferias
gremial1039153gremial
gremials1136133gremials
haemins122811393haemins
hemins113417563_hemins
hyenas1288953hye_nas
hyphemias2245613hyphemias
kalmias1347973kalmias
lamias85020613_lamias
lemmas10349163_lemmas
medias93620783_medias
myelins1237353myelins
myomas1338293myom_as
myopias14308143myopias
nemas75321573_nem_as
obelias9279033obelias
paellas9411413paellas
pampas124913993p_ampas
peas65755063p_e__as
peeries93623023peeries
peewits12105873peewits
peins76128063p_e_ins
pekins121812233p_ekins
pembinas1454133p_embinas
pemican1348153p_emican
pemicans1447033p_emicans
penial84120893p_enial
penis75129323p_eni_s
perils84121853p_erils
peris75537073p_eri_s
permian112612283permian
permits11314003permits
pewits112810683p_ewits
phobias14228183phobias
pias66542553p___ias
pietas84516503pie_tas
pieties9419223pieties
pigmies122610993pigmies
pimas94725103p_im_as
pleas75627033ple__as
pleiad947833ple_iad
pleiads1045223ple_iads
pleuras937413pleuras
pneumas1145103pneumas
poems95715553poem__s
poesies93217403poesies
poetics11312073poetics
polemics1448183polemics
pommies133712843pommies
prebids12399873prebids
precis103416703preci_s
predial103815413predial
preemies12512193preemies
prelims1139823prelims
preman104117453prem_an
premeal11310513premeal
premeds12389583premeds
premie103617993premi_e
premier113515633premier
premiers122911653premiers
premise113818553premise
premises123018273premises
premium13310363premium
premiums1437533premiums
premix173710333premi_x
premixes193110083premixes
premixt183510663premixt
prexies163415003prexies
primas104418103prim_as
proemial1249183proemial
pterins9812993pterins
pumas95121563p_um_as
pyaemic1645873pyaemi_c
pyas96225703py___as
pyelitis1346583pyelitis
pyes95528993pye___s
pygmean1542223pygmean
pyins105815863py__ins
pyjamas21263523pyjamas
pyknics1842483pyknics
pyosis114012123pyosi_s
pyramids1645643pyramids
pyrexia19225463pyrexia_
pyrexial20234963pyrexial
pyrolas1239863pyrolas
pyuria1136953pyuria_
pyxies18338293py_xies
pyxis17458633py_xi_s
redias74523603_redias
reemits9611303reemits
remiss84216353_remiss
remits85622943_remits
sapremias1344953sapremias
semis74623533_semi_s
sepias83616103_sepias
stemmas11256973stemmas
taenias7311283taenias
tenias64720073_tenias
toxemias1744733toxemias
ulemas888963ulem_as
uraemias1046043uraemias
uremia82910893uremia_
viremias1345873viremias
xenias133712973_xenias
yeas78638423_ye__as
yentas94614213_yentas
yerbas11119293_yerbas
yetis85418393_yeti_s
zamias174212923_zamias

Search took 9 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.1601116818.8
2DLD Change Limit1340271448.01316726.2
3Display Results1441440.0632285.7
 (SQL Overall)1786911448.23621696.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.