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

136 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
protease1020989(None) 
proteas92015121proteas_
proteases112110831proteases
proteose10229411proteose
pretense10199822pretense
propense122410102propense
prophase15410242prophase
protases102115032prot_ases
protea82214762protea__
protean92412192protea_n
proteans102811542proteans
protege1059152prote_ge
protegee1156962protegee
proteges1149922proteges
proteide11239722proteide
proteinase1244532proteinase
proteome12228422proteome
proteoses112211012proteoses
protest9317532prote_st
proteus92511592proteus_
proteuses11238992proteuses
protrade1148212protrade
crease85519573cr__ease
frottage1245083frottage
grease75416233gr__ease
notecase1044823_notecase
pease75231113p___ease
pectase112410363pect_ase
permease1246503permease
please84315733p__lease
plottage1144433plottage
poetise9314043p_oetise
poleaxe1656303p_oleaxe
portage103013643port_age
porterage1245763porterage
porters93722703porters_
postbase1246443postbase
potage92715903p_ot_age
potash1138273p_ot_ash
potence11711363p_otence
pottage103310603p_ottage
prase76128753pr___ase
praters94921653praters_
prates84633163prate_s_
precrease1345233precrease
prepense12238943prepense
prese75228383pr__e_se
pretape113511623pret_ape
pretaste10139523pret_aste
pretence122312123pretence
pretenses112210593pretenses
pretest9517633prete_st
proas75028803pro__as_
probate11414483pro_bate
probers113514583probers_
probes104119453probe_s_
process11310403proce_ss
processed1446803processed
processer1346893processer
processes13310233processes
procreate1348133procreate
proems104711163pro_ems_
proette9312363pro_ette
proettes10312763proettes
profane122111863pro_fane
profess1237713profe_ss
professed1545243professed
professes1437873professes
profuse1237153pro_fuse
prognose1146463prognose
prograde1247183prograde
projets1639163projets_
prolapse12134913prolapse
prolate9419793pro_late
prolegs10379993prolegs_
prolepses13126193prolepses
proles84627203prole_s_
promenade1485693promenade
promise113415843pro_mise
pronate9418873pro_nate
propane112716153pro_pane
propels113412843propels_
propene112716043prope_ne
propenes122816513propenes
propers113619033propers_
prophage1649433prophage
prophases16411063prophases
propose112714843pro_pose
prorate9418733pro_rate
prose75835123pro___se
prosers94219643prosers_
proses84733473prose_s_
prostate10314533prostate
prostrate11412483prostrate
protasis102411973prot_asis
protect11313633prote_ct
protected14158653protected
protecter13179103protecter
protects1239743protects
protegees1275393protegees
protei82615313prote__i
proteid103513673prote_id
proteides12238783proteides
proteids11259943proteids
protein92414733prote_in
proteinases1344523proteinases
proteins102114283proteins
protend104012793prote_nd
protended1336803protended
protends113010353protends
protensive1546203protensive
proteomes13248653proteomes
protested12159113protested
protester111510483protester
protests10310493protests
protheses1449073protheses
protist9320223prot_ist
protonate11412573protonate
protons93118003protons_
protract12510603protract
protrude1144703protrude
protyle12229453prot_yle
protyles13249833protyles
protyls12298463protyls_
provers123817793provers_
proves114322253prove_s_
prowess1237903prowe_ss
prowesses1437193prowesses
prowest12311533prowe_st
release7312763_release
roseate7613453_roseate
rotas54827723_rot_as_
rotate63320343_rot_ate
rotes56143903_rote_s_
tease55428713___tease
urease64516993ur__ease

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.436409841.7
2DLD Change Limit1461621367.97018339.0
3Display Results1361360.0632158.7
 (SQL Overall)1786911368.46921099.4
 
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.