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

73 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
protegee115696(None) 
protege1059151proteg_e
protegees1275391protegees
proteges1149921proteges
protease10209892protease
proteide11239722proteide
proteome12228422proteome
proteose10229412proteose
cortege1098953corteg_e
corteges1198823corteges
photogene1547783photogene
pongee94920193p_o_ngee
portage103013643portag_e
portaged12228463portaged
portages112613223portages
portered112311543portered
potage92715903p_otag_e
potages102416423p_otages
poteen83514263p_ote_en
potence11711363p_otence
preteen939873prete_en
pretence122312123pretence
pretense10199823pretense
prithee1239933prit_hee
proceed12310553proce_ed
proette9312363pro_ette
proettes10312763proettes
progged12409803pro_gged
progger11319373pro_gger
proleg94612113proleg__
prolegs10379993proleg_s
prologed12189213prologed
prologue1146833prologue
promisee122711333promisee
pronged113912393pro_nged
propene112716043prope_ne
propenes122816513propenes
propense122410103propense
properer1259203properer
prorogue1145243prorogue
protases102115033protases
protea82214763prot__ea
protean92412193prote_an
proteans102811543proteans
proteas92015123prote_as
proteases112110833proteases
protect11313633prote_ct
protected14158653protected
protecter13179103protecter
protects1239743protects
protei82615313prot__ei
proteid103513673prote_id
proteides12238783proteides
proteids11259943proteids
protein92414733prote_in
proteins102114283proteins
protend104012793prote_nd
protended1336803protended
protends113010353protends
proteomes13248653proteomes
proteoses112211013proteoses
protest9317533prote_st
protested12159113protested
protester111510483protester
protests10310493protests
proteus92511593prote_us
proteuses11238993proteuses
protheses1449073protheses
protrade1148213protrade
protrude1144703protrude
protyle12229453prot_yle
protyles13249833protyles
prythee1545383pryt_hee

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 Filter1786911461620.423422437.4
2DLD Change Limit146162737.00020880.3
3Display Results73730.0302433.3
 (SQL Overall)178691737.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.