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

177 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
protects123974(None) 
projects1936411projects
prosects1239471prosects
protect11313631protect_
protests10310491protests
portents103512822portents
prefects1598132prefects
prelects1299722prelects
pretests10310012pretests
pretexts1735602pretexts
products1376512products
project1838452project_
projets1639162proje_ts
prosect11313392prosect_
prospects1545102prospects
proteans102811542proteans
proteas92015122prote_as
protected14158652protected
protecter13179102protecter
protecters14168262protecters
protector13169532protector
protectors142010142protectors
proteges1149922proteges
proteids11259952proteids
proteins102114282proteins
protends113010352protends
protest9317532protest_
proteus92511592prote_us
protists10313362protists
protracts1347022protracts
acrolects1344333acrolects
biotechs15123853biotechs
corrects1259573corrects
detects104011093_detects
erects84116183er__ects
erotics91914153erotic_s
motets84216193_mote_ts
pandects1335843pandects
patents94815203p_atents
perfects15107353perfects
photics142810483photic_s
piolets93513193piole_ts
poets76024443p_o_e_ts
polecats1248833p_olecats
porrect1159743porrect_
portends11358963portends
portent93619643portent_
porters93722703porte_rs
porticos1238383porticos
poteens92910883p_oteens
potences12710693p_otences
potent84223353p_otent_
praefects1642883praefects
praelects1354363praelects
praters94921653prate_rs
prates84633163prate__s
preacts113211363pr_eacts
precents123015043precents
precepts14268893precepts
precis103416703pr__ecis
precuts111710473pr__ecuts
predicts1339623predicts
preelects1356083preelects
preerects1345413preerects
prefect141011073prefect_
preheats1339423preheats
prelect111013833prelect_
presents103315643presents
presets94216423prese_ts
prests84021263pr__ests
preteens1038123preteens
pretells1047333pretells
pretences132312613pretences
pretends11299113pretends
preterits11410973preterits
preterms1237223preterms
pretest9517633pretest_
pretext1639663pretext_
pretreats1146933pretreats
prevents133012303prevents
priests93810863pr_iests
privets122910053prive_ts
probers113514583probe_rs
probes104119453probe__s
probits112712573pro_bits
proceeds1335983proceeds
process11310403proce_ss
produces1347903produces
product1279233product_
proems104711163pro_e_ms
proette9312363pro_ette
proettes10312763proettes
profess1237713profe_ss
profits122911243pro_fits
projected21165823projected
projector20186683projector
projectors21187173projectors
projet15315183proje_t_
prolegs10379993prole_gs
proles84627203prole__s
prompts1337473pro_mpts
propels113412843prope_ls
propends13249173propends
propenes122816513propenes
propers113619033prope_rs
property1547073property
prophets1539503prophets
propjets1935493propjets
prosected14158633prosected
prosector13208533prosector
prosectors14199123prosectors
prosecute1345953prosecute
prosecutes1445673prosecutes
prosers94219643prose_rs
proses84733473prose__s
prospect1447893prospect_
prospectus1643413prospectus
protases102115033protases
protasis102411973protasis
protea82214763prote__a
protean92412193prote_an
protease10209893protease
proteases112110833proteases
protectant1446913protectant
protectants1554363protectants
protecting151910213protecting
protection14511473protection
protections15510703protections
protective1748423protective
protectory17157483protectory
protectress1553133protectress
protege1059153prote_ge
protegee1156963protegee
protegees1275393protegees
protei82615313prote__i
proteid103513673prote_id
proteide11239723proteide
proteides12238793proteides
protein92414733prote_in
protend104012793prote_nd
proteome12228423proteome
proteomes13248653proteomes
proteose10229413proteose
proteoses112211013proteoses
protested12159113protested
protester111510483protester
protesters12169393protesters
protestor11178493protestor
protestors12169313protestors
proteuses11238993proteuses
protheses1449073protheses
prothesis1449433prothesis
protist9320223protist_
protiums1238563protiums
protocol1246473protocol
protocols1347203protocols
protons93118003prot_ons
protract12510603protract_
protyles13249833protyles
protyls12298463prot_yls
proverbs15315583proverbs
provers123817793prove_rs
proves114322253prove__s
provosts1336083provosts
prowess1237903prowe_ss
prowest12311533prowest_
refects124012743_refects
rejects163910693_rejects
resects94115593_resects
retests73813853_retests
rodents8611543_rodents
rosets65819953_rose_ts
rotes56143903_rote__s
rotguts833763_rotguts
trajects1744533trajects
trisects1035983trisects
urtexts1433143ur_texts

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.423422437.4
2DLD Change Limit1461621778.18617855.1
3Display Results1771770.0802212.5
 (SQL Overall)1786911778.68920565.2
 
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.