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

200 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
pharoses1331031(None) 
agaroses938822agaroses
chaoses124715122cha_oses
charases131312762charases
pareses94718882p_areses
parises94827182p_arises
paroles95025882p_aroles
parses85534702p_ar_ses
pharisee1347602pharisee
pharisees1444632pharisees
pharos11312062pharo__s
phases114618402pha__ses
phereses1348092phereses
phimoses1537202phimoses
phrases12711462ph_rases
proses84733472p__roses
saroses73619332_saroses
acarboses1345083acarboses
agarose838663agarose_
amarones10311353amarones
amauroses1144473amauroses
aphaereses1553163aphaereses
aphereses1466423aphereses
aphorises14310003aphorises
arises65233803__arises
arkoses113910833__arkoses
arose55832083__arose_
arouses74921293__arouses
arses55733873__ar_ses
broses86524403__broses
carouses10614503_carouses
carses85233653_car_ses
chaises124317493cha_ises
chalones13312173chalones
chamises153513313chamises
chamoises16327933chamoises
charades141310853charades
chares115631803char__es
charges134615983char_ges
charisms15710263charisms
charlies133414233charlies
chases115128233cha__ses
chasses124017503cha_sses
chausses1345963chausses
chayotes1636503chayotes
chloroses1447683chloroses
chooses125717423ch_ooses
choruses1339983choruses
choses115825133ch__oses
chromes142914933ch_romes
claroes93113733claro_es
cyanoses1337423cyanoses
eroses65327053__eroses
fibroses1345973fibroses
garotes8614563_garotes
gharries12318203gharries
haloes94623863_halo_es
hanses95022633_ha_nses
haoles94919803_ha_oles
haploses1338853_haploses
harass9313943_haras_s
harasses11311033_harasses
hardies114923233_hardies
hardnoses1346233_hardnoses
hardset113415833_hardset
hares86255543_har__es
harness102413933_harness
harpies123818313_harpies
harries103525493_harries
hawses125113993_ha_wses
hearses104414533hear_ses
heroes94923823_hero_es
hexoses17228883_hexoses
hidroses1237903hidroses
horses94729343_hor_ses
hoses85443173_h__oses
kaross101910013_karos_s
karosses1236493_karosses
marses84827113_mar_ses
narcoses103910543_narcoses
necroses10310563necroses
nephroses1446303neph_roses
neuroses8310153neuroses
padrones112711043padrones
papooses1248053papooses
parades104121463p_arades
paradoses122510253paradoses
parches143720003p_arches
parcloses1347963p_arcloses
pares77164483p_ar__es
paresis93315093p_aresis
parges94529543p_ar_ges
paries84742513p_ar_ies
parishes13314753p_arishes
parles86334403p_ar_les
parodies11313693p_arodies
parodos103011753p_arodos
parole84425253p_arole_
paroled104217613p_aroled
parolee94119633p_arolee
parolees104313973p_arolees
parols84722613p_aro_ls
parous84024163p_aro_us
parries93925843p_arries
parse75236993p_ar_se_
parsec105914483p_ar_sec
parsecs11429923p_ar_secs
parsed96323893p_ar_sed
parser84822373p_ar_ser
parsers94118153p_ar_sers
parsons93516873p_arsons
parties93230863p_arties
parures9512693p_arures
parvises133911913p_arvises
pases75346503p_a__ses
passes86030473p_a_sses
pathoses13412773pathoses
pauses84621473p_a_uses
pavises125315493p_avises
peases85229473pea__ses
pentoses10312893pentoses
peploses1269463peploses
perses85428063p_er_ses
peruses94018163p_eruses
petasoses1145443petasoses
phages125213513pha__ges
phagosomes1863693phagosomes
phalaropes1754353phalaropes
phalluses1444263phalluses
pharaohs1644493pharaohs
pharynges1842883pharynges
pharynxes2441923pharynxes
phase104617213pha__se_
phased124011973pha__sed
phasis114614923pha__sis
pheresis1377633pheresis
phimosis1546193phimosis
phloxes1935513ph_loxes
phones114121213ph__ones
phorates13413043phorates
phoresies1447993phoresies
photoset13414283photoset
photosets1447823photosets
phrase11109903ph_rase_
phrased1387383ph_rased
phthises1645723phthises
phyleses1645183phyleses
physes14399783ph__yses
polarises11514073polarises
porose84818743p_orose_
poses74642763p___oses
praises94121103pra_ises
prases84429023p__rases
praxises1739063praxises
primroses1344843primroses
prises84133173p__rises
probes104119453p__robes
proles84627203p__roles
proposes122515973proposes
prose75835123p__rose_
prosed94921093p__rosed
proser84223463p__roser
prosers94219643p__rosers
prosos85718553p__rosos
pross76529403p__ros_s
prosses94019513p__rosses
proves114322253p__roves
psiloses1036443psiloses
ptoses83514673p__toses
purposes1237823purposes
purses84826373p_ur_ses
pycnoses1554973pycnoses
pyknoses1783573pyknoses
pyoses114314303p__yoses
pyranoses1445853pyranoses
pyrones123113303p_yrones
pyropes142210193p_yropes
pyrosis12411653p_yrosis
pyrroles1345453pyrroles
rearouses9310203rearouses
rhamnoses14104183rhamnoses
roses56445773___roses
sarodes84216143_sarodes
shakoes144510013shako_es
shamuses1336153shamuses
shares95236413shar__es
sharpies13411223sharpies
soroses73117483_soroses
starnoses9157153starnoses
sucroses1039933sucroses
thermoses1447973thermoses
throes97518673th_ro_es
thrones105715843th_rones
thyrses1335023thyr_ses
uphroes1236303uph_ro_es
vamoses1239143_vamoses
varuses10310623_varuses
viroses10310533_viroses
wharves16457133whar_ves
xeroses143612823_xeroses

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 Filter1786911461620.326548131.9
2DLD Change Limit1461622007.89018525.0
3Display Results2002000.0802500.0
 (SQL Overall)1786912008.29621539.4
 
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.