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

217 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
protege105915(None) 
protegee1156961protegee
proteges1149921proteges
cortege1098952cortege
portage103013642portage
potage92715902p_otage
proette9312362proette
proleg94612112proleg_
prolegs10379992prolegs
propene112716042propene
protea82214762prote_a
protean92412192protean
proteas92015122proteas
protease10209892protease
protect11313632protect
protegees1275392protegees
protei82615312prote_i
proteid103513672proteid
proteide11239722proteide
protein92414732protein
protend104012792protend
proteome12228422proteome
proteose10229412proteose
protest9317532protest
proteus92511592proteus
protyle12229452protyle
bootee84323023boote_e
brokage1436673brokage
carotene1039133carotene
corteges1198823corteges
dotage82711613_dotage
ecotage1036883ecotage
erotize16311663erotize
flotage1136683flotage
footage1148843footage
frogeye1443813frogeye
fromage1336753fromage
frontage1296243frontage
frottage1245083frottage
parolee94119653parole_e
pattee84323383patte_e
pentene9313793pentene
peonage1048723peonage
phoebe1335003pho_ebe
phoneme1446203phoneme
photog12379813photog_
photogs13358213photogs
picotee11311473picote_e
pilotage1145373pilotage
plottage1144433plottage
pongee94920193p_ongee
portaged12228463portaged
portages112613223portages
ported94223243porte_d
portend103411193portend
portent93619643portent
porter84224413porte_r
porterage1245773porterage
portered112311553portered
porters93722703porters
portiere1038773portiere
postage103214853postage
potages102416423p_otages
poteen83514263p_oteen
potence11711363p_otence
potent84223353p_otent
potpie103412433p_otpie
potsie83916033p_otsie
pottage103310603pottage
pottle84416103p_ottle
prate75135983prat__e
prated94924923prate_d
prater84825353prate_r
praters94921653praters
prates84633163prate_s
prattle9208833prattle
precede1239653precede
pree67044733pr__e_e
presage10312293presage
prese75228383pr__ese
prestige11310733prestige
pretape113511623pretape
preteen939873preteen
pretell938243pretell
pretence122312123pretence
pretend104011013pretend
pretense10199823pretense
preterm11310163preterm
pretest9517633pretest
pretext1639663pretext
pretype14387483pretype
primage12169143primage
prisere9310943prisere
prithee1239933prithee
probate11414483probate
probe94320813pro__be
probed114114823probe_d
prober104516073probe_r
probers113514583probers
probes104119453probe_s
proceed12310553proceed
process11310403process
procure1138573procure
prodigy1435573prodigy
produce1267513produce
proem94818273pro_e_m
proems104711163pro_ems
proettes10312763proettes
profane122111863profane
profess1237713profess
profile123211153profile
profuse1237153profuse
prog75729003pro__g_
progeny1389463progeny
progged12409803progged
progger11319373progger
progs86624153pro__gs
project1838453project
projet15315183proje_t
projets1639163projets
prolate9419793prolate
prole74527793pro__le
proles84627203prole_s
proline92321593proline
prolog94212973prolog_
prologed12189213prologed
prologs103512133prologs
prologue1146833prologue
prolonge11388403prolonge
promine112819443promine
promise113415843promise
promote11313143promote
promulge1343043promulge
pronate9418873pronate
prone75332623pro__ne
pronely12310253pronely
prong85218113pro_ng_
pronged113912393pronged
prongs94314483pro_ngs
propane112716153propane
propel103714063prope_l
propels113412843propels
propend123311273propend
propenes122816513propenes
propense122410103propense
proper104319953prope_r
properer1259203properer
propers113619033propers
prophage1649433prophage
propine113020213propine
propone112716303propone
propose112714843propose
prorate9418733prorate
prorogue1145243prorogue
prose75835123pro__se
prosect11313393prosect
prosed94921103prose_d
proser84223463prose_r
prosers94219643prosers
proses84733473prose_s
prossie91812963prossie
prostate10314533prostate
prostie91617743prostie
prostyle13187273prostyle
protases102115033protases
proteans102811543proteans
proteases112110833proteases
protected14158653protected
protecter13179103protecter
protects1239743protects
proteides12238793proteides
proteids11259953proteids
proteins102114283proteins
protended1336803protended
protends113010353protends
proteomes13248653proteomes
proteoses112211013proteoses
protested12159113protested
protester111510483protester
protests10310493protests
proteuses11238993proteuses
protheses1449073protheses
protist9320223protist
protium11312293protium
proton84318893prot_on
protons93118003protons
protrade1148213protrade
protrude1144703protrude
protyl11308213prot_yl
protyles13249833protyles
protyls12298463protyls
prove104823193pro__ve
proved125016033prove_d
proven114314773prove_n
prover113819723prove_r
proverb14378213proverb
provers123817793provers
proves114322253prove_s
provide1339853provide
provoke1676123provoke
prower114218123prowe_r
prowess1237903prowess
prowest12311533prowest
prythee1545383prythee
puttee85919723putte_e
pyroxene2045083pyroxene
renege72713763_renege
retene69224273_retene
rootage839053rootage
rotate63320343_rotate
rotche114311983_rotche
rote46249023_rot__e
rotes56143903_rote_s
rotte54625933_rot_te
rouge65423443_ro_uge
urodele845963urodele
wrote84717483wrot__e

Search took 10 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272178.75015317.4
3Display Results2172170.0762855.3
 (SQL Overall)1786912179.23219355.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.