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

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

53 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
prothoraxes235451(None) 
prothoraces1855251prothoraces
prothorax2145222prothorax__
hydrothoraxes3062593hydrothoraxes
mesothoraxes2461853mesothoraxes
phototaxes2246663phot_otaxes
prophylaxes2862883prophylaxes
prothoracic2054003prothoracic
protonates12411693prot_onates
thoraxes1896363___thoraxes
erythorbates2082074erythorbates
hydrothoraces2562944hydrothoraces
mesothoraces1962074mesothoraces
metathoraxes2462684metathoraxes
orthodoxes2153494or_thodoxes
pastorales1247134past_orales
pastorates12410144past_orates
phorates13413044p___horates
phototaxies2356224phot_otaxies
phototaxis2256504phot_otaxis
plethoras1444804plethora__s
pneumothoraxes2891384pneumothoraxes
porterages1345974port_erages
portholes14410374portho__les
potholes13312934p_otho__les
pothouses1449044p_otho_uses
priorates11410764pr__iorates
prophages1749764proph__ages
prophases16411064proph__ases
prophylaxis2872644prophylaxis
propionates1545534propionates
prorates10418074pr___orates
prorogates1347314pro_rogates
prostrates12411994pro_strates
protases102115034prot___ases
proteases112110834prot__eases
protectorates1752864protectorates
proteinases1344524proteinases
proteolyses1653664proteolyses
proteomes13248654proteo__mes
proteoses112211014proteo__ses
protheses1449074proth__eses
protonate11412574prot_onate_
protonated1348594prot_onated
prototypes1745924prot_otypes
protoxides2046284prot_oxides
protracts1347024prot__racts
protrade1148214prot__rade_
protrudes1245174prot__rudes
storaxes1536884__st_oraxes
thoraces13118944___thoraces
tropotaxes1953834tro_potaxes
urochordates1862114urochordates

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 Filter1786911488190.420425454.8
2DLD Change Limit148819538.47017570.1
3Display Results53530.0163312.5
 (SQL Overall)178691538.90620064.1
 
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.