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

58 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
protegees127539(None) 
protegee1156961protegee_
proteges1149921proteg_es
proteases112110832proteases
protege1059152proteg_e_
proteides12238782proteides
proteomes13248652proteomes
proteoses112211012proteoses
proteuses11238992proteuses
corteges1198823corteg_es
photogenes1648883photogenes
pongees104212543p_o_ngees
portages112613223portag_es
porteress1137933porteress
potages102416423p_otag_es
poteens92910883p_ote_ens
potences12710693p_otences
preteens1038123prete_ens
pretences132312613pretences
pretenses112210593pretenses
proceeds1335983proce_eds
processes13310233processes
prodigies1346953prodigies
proettes10312763pro_ettes
professes1437873professes
progenies12314123progenies
proggers12258163pro_ggers
prolegs10379993proleg__s
prolepses13126193prolepses
prologues1246903prologues
promisees13246863promisees
proneness11310443proneness
propenes122816513prope_nes
prorogues1244883prorogues
protases102115033prot_ases
proteans102811543prote_ans
proteas92015123prot__eas
protease10209893protease_
protected14158653protected
protecter13179103protecter
protecters14168253protecters
protects1239743prote_cts
proteide11239723proteide_
proteids11259943prote_ids
proteins102114283prote_ins
protended1336803protended
protends113010353prote_nds
proteome12228423proteome_
proteose10229413proteose_
protested12159113protested
protester111510483protester
protesters12169383protesters
protests10310493prote_sts
proteus92511593prot__eus
protheses1449073protheses
protrudes1245173protrudes
protyles13249833prot_yles
prowesses1437193prowesses

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.406440125.6
2DLD Change Limit148641586.42323142.0
3Display Results58580.0163625.0
 (SQL Overall)178691586.84526105.3
 
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.