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

252 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
protein9241473(None) 
protean92412191protean
protei82615311protei_
proteid103513671proteid
proteins102114281proteins
crocein1138072crocein
poteen83514262p_oteen
preteen939872preteen
prochein1547522prochein
protamin121210542protamin
protea82214762prote_a
proteans102811542proteans
proteas92015122proteas
protect11313632protect
protege1059152protege
proteide11239722proteide
proteids11259952proteids
proteinic1346882proteinic
protend104012792protend
protest9317532protest
proteus92511592proteus
proton84318892prot_on
proven114314772prove_n
acrolein1045853acrolein
aprotic112715243aprot_ic
biotin83215833biot_in
broken124011523broke_n
bromelin1246343bromelin
bromin102615693bro_min
carotin92216733carot_in
codein94916723_codein
cortin82423153cort_in
cretin82917913cret_in
croceine1248033croceine
croceins1238103croceins
croton84415453crot_on
cystein1246053cystein
erotic82620273erot_ic
frothing15208533frothing
frozen18408443froze_n
gratin74520583grat_in
groin65521083gro__in
hordein1138753hordein
kronen10348913krone_n
lomein8410203_lomein
lutein6311263_lutein
nonprotein1254823nonprotein
olein5316003__olein
orcein838183or_cein
parotic112518043parot_ic
parotid102915513parot_id
parotoid11410033parotoid
pastern94415063pastern
paten74827343p_ate_n
patin76832853p_at_in
patten84418193patte_n
pattern93712053pattern
pecten102711103pecte_n
pectin102615533pect_in
pein65834943p___ein
pertain92714963pertain
photic133316443phot_ic
photoing1439073photoing
photon1111514833phot_on
phytin14459013phyt_in
pirogen1038263piroge_n
platen84518203plate_n
plotline1037643plotline
plotting113011013plotting
plotzing20276153plotzing
plutei8408903plutei_
poetic10416843p_oetic
poleis86018353p_oleis
poleyn1157323p_oleyn
poplin10413483p_oplin
ported94223243porte_d
portend103411193portend
portent93619643portent
porter84224413porte_r
portering122012303portering
porters93722703porters
porting103021783port_ing
portion9615493portion
posteen93512623posteen
postern93615613postern
postin83521033p_ostin
poteens92910883p_oteens
potent84223353p_otent
potheen12257893p_otheen
potion84519573p_otion
potline91015233p_otline
potman102813573p_otman
potmen102713093p_otmen
potpie103412433p_otpie
potsie83916033p_otsie
potteen9319673potteen
potting103720893p_otting
prate75135983prate__
prated94924923prate_d
prater84825353prate_r
praters94921653praters
prates84633163prate_s
prating103424453prat_ing
preeing103817673pr_eeing
preen75925053pr__een
premen105017803preme_n
preobtain1343993preobtain
preteens1038123preteens
pretell938243pretell
pretend104011013pretend
preterit10315853preterit
preterm11310163preterm
pretest9517633pretest
pretext1639663pretext
pretrain10310923pretrain
pretrim11310783pretrim
probe94320813probe__
probed114114823probe_d
prober104516073probe_r
probers113514583probers
probes104119453probe_s
probing123314443pro_bing
probit103218353pro_bit
procaine12312273procaine
proceed12310553proceed
process11310403process
prochain1548483prochain
prodding13189343prodding
proem94818273pro_e_m
proems104711163pro_ems
proette9312363proette
profess1237713profess
profit113016273pro_fit
progeny1389463progeny
progeria1147943progeria
progestin1248423progestin
progging132610383progging
progun968783pro_gun
project1838453project
projet15315183proje_t
projets1639163projets
prolamin12139753prolamin
prolan8414693pro_lan
prole74527793prole__
proleg94612113prole_g
prolegs10379993prolegs
proles84627203prole_s
proline92321593pro_line
prolix1538683pro_lix
promine112819443pro_mine
promoing13310463promoing
prone75332623prone__
pronely12310253pronely
pronging123511843pronging
pronoun939033pronoun
proofing1439313proofing
propel103714063prope_l
propels113412843propels
propend123311273propend
propene112716043propene
proper104319953prope_r
properdin1446273properdin
propers113619033propers
propine113020213pro_pine
propman1339063propman
propmen1338763propmen
propping122811673propping
propria1149933propria
prosaic11311163prosaic
prose75835123prose__
prosect11313393prosect
prosed94921103prose_d
proser84223463prose_r
prosers94219643prosers
proses84733473prose_s
prosier93817493prosier
prosing103319383pro_sing
prosit85124593pro_sit
prossie91812963prossie
prostie91617743prostie
prosties101421193prosties
protamine131310913protamine
protamins131410773protamins
protasis102411973protasis
protatic12314753protatic
protease10209893protease
protecting151910213protecting
protection14511473protection
protects1239743protects
protegee1156963protegee
proteges1149923proteges
proteides12238793proteides
proteinase1244533proteinase
protending1446813protending
protends113010353protends
proteome12228423proteome
proteomic1546743proteomic
proteose10229413proteose
protesting131910253protesting
protests10310493protests
prothesis1449433prothesis
prothetic161010073prothetic
protist9320223protist
protium11312293protium
protonic12314593protonic
protons93118003protons
protoxid1849143protoxid
protyl11308213prot_yl
protyle12229453protyle
protyls12298463protyls
prounion1046823prounion
prove104823193prove__
proved125016033prove_d
prover113819723prove_r
proverb14378213proverb
provers123817793provers
proves114322253prove_s
proving134214073pro_ving
prower114218123prowe_r
prowess1237903prowess
prowest12311533prowest
prowling1449993prowling
proxemic2146153proxemic
proxies163014933proxies
pterin81014153p__terin
ptomain1146963ptomain
ptotic102713373ptot_ic
pyrogen1337353pyroge_n
ratlin64116523_ratlin
rein46040893_r__ein
retain64523283_retain
robbin103611183_robbin
robin74820283_ro_bin
rosin55325313_ro_sin
rote46249023_rote__
rotes56143903_rote_s
roti46332933_rot_i_
rotis56327063_rot_is
rotten64115433_rotten
rotting82919683_rotting
rouen54920903_roue_n
roven85521973_rove_n
rowen84921153_rowe_n
rutin55421343_rut_in
stein54620543__stein
stotin63215063stot_in
torten65314353torte_n
tropin83316753tro_pin
trothing122410843trothing
trotline8310023trotline
trotting92510913trotting
wrote84717483wrote__

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 Filter1786911340270.393454684.5
2DLD Change Limit1340272526.71619956.4
3Display Results2522520.0803150.0
 (SQL Overall)1786912527.18924856.2
 
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.