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

69 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
prothesis144943(None) 
prosthesis1546151prosthesis
protheses1449071protheses
prophesies17107892prophesies
prostheses1546552prostheses
protasis102411972prot_asis
protests10310492prot_ests
prothetic161010072prothetic
anthesis11312503_anthesis
apotheosis1553653apotheosis
brothels13277073brothe_ls
brothers133410833brothe_rs
diathesis1345533diathesis
epenthesis1593763epenthesis
esthesis1148463_esthesis
frothers14279813frothe_rs
hypothesis2157253hypothesis
orthosis1148193or_thosis
parchesis16318213parchesis
parenthesis1654053parenthesis
phthisis1654443p_hthisis
plotless10256793plotles_s
portless10310643portles_s
portress1038323portres_s
potheads14298543p_otheads
potheens13266483p_otheens
potherbs15387123p_otherbs
pothers123818623p_othe_rs
pretests10310013pret_ests
process11310403pro_ces_s
prochein1547523proche_in
proclisis1346773proclisis
profess1237713pro_fes_s
prognosis1246723prognosis
progress1137023progres_s
prolepsis13125063prolepsis
prophases16411063prophases
prophasic1848473prophasic
prophecies1996503prophecies
prophesied1894793prophesied
prophesier17114333prophesier
prophesiers18113153prophesiers
prophesy1844453prophes_y
prophetic18710583prophetic
prophets1539503prophe_ts
proptosis1348203proptosis
prosthetic1797353prosthetic
prosthetics18135203prosthetics
prosthetist1655883prosthetist
protases102115033prot_ases
proteans102811543prot_eans
proteas92015123prot_e_as
proteases112110833proteases
protects1239743prot_ects
proteges1149923prot_eges
protei82615313prot_e_i_
proteid103513673prot_e_id
proteids11259943prot_eids
protein92414733prot_e_in
proteins102114283prot_eins
protends113010353prot_ends
proteoses112211013proteoses
protest9317533prot_es_t
proteus92511593prot_e_us
proteuses11238993proteuses
protists10313363prot_ists
prowess1237903pro_wes_s
synthesis1546053synthesis
thesis94913733___thesis

Search took 8 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.1701051123.5
2DLD Change Limit148641697.25320493.7
3Display Results69690.0302300.0
 (SQL Overall)178691697.45323975.7
 
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.