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 “protheses” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
protheses144907(None) 
prostheses1546551prostheses
prothesis1449431prothesis
prophases16411062prophases
prophesies17107892prophesies
prosthesis1546152prosthesis
protases102115032prot_ases
proteases112110832proteases
proteges1149922prot_eges
proteoses112211012proteoses
protests10310492prot_ests
proteuses11238992proteuses
antheses11311473_antheses
apotheces1644013apotheces
apotheoses1543873apotheoses
brothels13277073brothe_ls
brothered1546003brothered
brothers133410833brothe_rs
diatheses1345893diatheses
epentheses1563803epentheses
estheses1137783_estheses
frothers14279813frothe_rs
hypotheses2155763hypotheses
isotheres1246333isotheres
orthoses11311133or_thoses
parentheses1653973parentheses
pathoses13412773p_athoses
phthises1645723p_hthises
plotless10256793plotles_s
portholes14410373portholes
portieres1138213portieres
portless10310643portles_s
portress1038323portres_s
portresses1247313portresses
potheads14298543p_otheads
potheen12257893p_othe_en
potheens13266483p_otheens
potherbs15387123p_otherbs
pothered142311043p_othered
pothers123818623p_othe_rs
potholes13312933p_otholes
pothouses1449043p_othouses
pretenses112210593pretenses
pretests10310013pret_ests
prithee1239933prithe_e_
process11310403pro_ces_s
processes13310233processes
proclises1339543proclises
profess1237713pro_fes_s
professes1437873professes
prognoses1247533prognoses
progress1137023progres_s
progresses1347493progresses
prolapses13145573prolapses
prolepses13126193prolepses
promisees13246863promisees
promises122916763pro_mises
propenes122816513pro_penes
prophages1749763prophages
prophase15410243prophase_
prophecies1996503prophecies
prophesied1894793prophesied
prophesier17114333prophesier
prophesiers18113153prophesiers
prophesy1844453prophes_y
prophetess1744243prophetess
prophets1539503prophe_ts
proposes122515973pro_poses
proptoses1349873proptoses
proses84733473pro___ses
prosses94019513pro__sses
protasis102411973prot_asis
proteans102811543prot_eans
proteas92015123prot_e_as
protease10209893protease_
protects1239743prot_ects
protege1059153prot_ege_
protegee1156963prot_egee
protegees1275393protegees
proteides12238783proteides
proteids11259943prot_eids
proteins102114283prot_eins
protends113010353prot_ends
proteomes13248653proteomes
proteose10229413proteose_
protest9317533prot_es_t
protested12159113prot_ested
protester111510483prot_ester
protesters12169383prot_esters
proteus92511593prot_e_us
prothetic161010073prothetic
protists10313363prot_ists
protrudes1245173protrudes
protyles13249833prot_yles
prowess1237903pro_wes_s
prowesses1437193prowesses
prythee1545383prythe_e_
syntheses1545683syntheses
theses96517973___theses
trochees132510183troche_es

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411006.39023261.5
3Display Results1001000.0502000.0
 (SQL Overall)1786911006.89325923.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.