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

128 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
protasis10241197(None) 
protases102115031protases
proptosis1348202proptosis
protamin121210542protamin
protamins131410772protamins
protatic12314752protatic
proteases112110832proteases
protests10310492protests
prothesis1449432prothesis
protists10313362protists
crasis85020473cr__asis
ectasis9249613_ectasis
entasis73012573_entasis
epistasis1144983epistasis
epitasis1047433epitasis
erotisms10310163erotisms
geotaxis1644183geotaxis
oasis56422553__o_asis
parataxis1845473parataxis
parotitis1149173parotitis
pectases122411193pectases
peltasts1035703peltasts
petasos948603p_etasos
petasus946363p_etasus
petsais938433p_etsais
phasis114614923p__hasis
portages112613223portages
portals94015563porta_ls
potages102416423p_otages
potamic13310853p_otamic
potash1138273p_otas_h
potashes1337833p_otashes
potassic1244923p_otassic
potsie83916033p_ot_sie
potsies93019483p_ot_sies
prases84429023pr__ases
praxis154012253pr__axis
precasts1239453precasts
pretapes122811533pretapes
pretaste10139523pretaste
pretastes11119423pretastes
pretests10310013pretests
proas75028803pro_a__s
probands13228393probands
probangs13256213probangs
probates12414283probates
proboscis1573643proboscis
procarps1445973procarps
process11310403proces_s
proclisis1346773proclisis
proctitis1348363proctitis
profanes132311573profanes
profess1237713profes_s
prognosis1246723prognosis
prolamin12139753prolamin
prolamins13159703prolamins
prolans9314273prola_ns
prolapses13145573prolapses
prolapsus13132683prolapsus
prolepsis13125063prolepsis
promises122916763promises
pronates10418373pronates
propanes122415823propanes
prophases16411063prophases
prophasic1848473prophasic
propolis12311403propolis
proposes122515973proposes
proptoses1349873proptoses
prorates10418073prorates
prosaic11311163prosa_ic
prosaism1268043prosaism
prosaisms1346273prosaisms
prosaist10611583prosaist
prosaists1157503prosaists
proses84733473pro__ses
prosit85124593pro__sit
prosos85718553pro__sos
pross76529403pro__s_s
prosses94019513pro_sses
prossie91812963pro_ssie
prossies101515233pro_ssies
prostates11314423prostates
prostatic13410853prostatic
prostatism1447743prostatism
prosthesis1546153prosthesis
protamine131310913protamine
protamines14149803protamines
proteans102811543proteans
proteas92015123prot_eas
protease10209893proteas_e
protects1239743protects
proteges1149923proteges
protei82615313prot_ei_
proteid103513673prot_eid
proteids11259953proteids
protein92414733prot_ein
proteins102114283proteins
protends113010353protends
proteoses112211013proteoses
protest9317533protes_t
proteus92511593prot_eus
proteuses11238993proteuses
protheses1449073protheses
protist9320223protis_t
protistic13410983protistic
protiums1238563protiums
protonic12314593protonic
protons93118003prot_ons
protoxid1849143protoxid
protoxids1947183protoxids
protracts1347023protracts
protyles13249833protyles
protyls12298463prot_yls
provisos1336913provisos
provosts1336083provosts
prowess1237903prowes_s
psoriasis1143853psoriasis
ptosis83611823p__tosis
pyosis114012123pyo__sis
pyrolysis1745493pyrolysis
pyrosis12411653pyro__sis
roasts64915413_ro_asts
romajis1635913_romajis
rotaries8315693_rotaries
rotas54827723_rota__s
rotates72819773_rotates
rotis56327063_rot__is
stasis63116873__stasis

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.453394461.4
2DLD Change Limit1461621287.89018525.0
3Display Results1281280.0462782.6
 (SQL Overall)1786911288.38921300.6
 
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.