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

164 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
proteans10281154(None) 
protean92412191protean_
proteas92015121protea_s
proteins102114281proteins
poteens92910882p_oteens
preteens1038122preteens
prolans9314272pro_lans
protea82214762protea__
protease10209892protease
proteases112110832proteases
protects1239742protects
proteges1149922proteges
proteids11259952proteids
protein92414732protein_
protend104012792prote_nd
protends113010352protends
protests10310492protests
proteus92511592prote_us
protons93118002prot_ons
brogans1049663bro_gans
cotans81317923_cot_ans
croceins1238103croceins
crotons93714373crot_ons
groans74815063gro__ans
oceans81211003__oceans
ortolans846553ortolans
paeans85118263p__aeans
pampeans1444703pampeans
partans94418283part_ans
pasterns104112623pasterns
patens84820863p_ate_ns
pattens95414923patte_ns
patterns10439943patterns
peans75437643p___eans
pectens11189203pecte_ns
photons123814433phot_ons
pitmans11188743p_itmans
platans93413123plat_ans
plateaus1035533plateaus
platens94213983plate_ns
poleyns1236113p_oleyns
portals94015563port_als
portend103411193porte_nd
portends11358963portends
portent93619643porte_nt
portents103512823portents
porters93722703porte_rs
portions10514413portions
portrays1345293portrays
posteens10309733posteens
posterns102713723posterns
poteen83514263p_oteen_
potent84223353p_ote_nt
potheads14298543p_otheads
potheens13266483p_otheens
potions93417423p_otions
potman102813573p_otman_
potteens10256793potteens
praters94921653prate_rs
prates84633163prate__s
precleans1344893precleans
preens85020113pr__eens
preheats1339423preheats
preplans1249613preplans
preteen939873preteen_
pretells1047333pretells
pretend104011013prete_nd
pretends11299113pretends
pretense10199823prete_nse
preterms1237223preterms
pretests10310013pretests
pretexts1735603pretexts
pretrains11410143pretrains
pretreats1146933pretreats
proas75028803pro__a_s
proband122710243pro_band
probands13228393pro_bands
probang12278383pro_bang
probangs13256213pro_bangs
probers113514583probe_rs
probes104119453probe__s
proceeds1335983proceeds
process11310403proce_ss
procreant1346253procreant
proems104711163pro_e_ms
proettes10312763proettes
profane122111863pro_fane
profanes132311573pro_fanes
profess1237713profe_ss
progeny1389463proge_ny
programs1339783programs
projects1936413projects
projets1639163proje_ts
prolan8414693pro_lan_
prolegs10379993prole_gs
proles84627203prole__s
pronouns1047213pronouns
propane112716153pro_pane
propanes122415823pro_panes
propels113412843prope_ls
propend123311273prope_nd
propends13249173propends
propene112716043prope_ne
propenes122816513propenes
propense122410103prope_nse
propers113619033prope_rs
propman1339063propman_
prosects1239473prosects
prosers94219643prose_rs
proses84733473prose__s
protamins131410773protamins
protases102115033protases
protasis102411973protasis
protect11313633prote_ct
protectant1446913protectant
protectants1554363protectants
protege1059153prote_ge
protegee1156963protegee
protegees1275393protegees
protei82615313prote__i
proteid103513673prote_id
proteide11239723proteide
proteides12238793proteides
proteinase1244533proteinase
proteinic1346883proteinic
proteome12228423proteome
proteomes13248653proteomes
proteose10229413proteose
proteoses112211013proteoses
protest9317533prote_st
protestant1247433protestant
protestants1354553protestants
proteuses11238993proteuses
protheses1449073protheses
prothesis1449433prothesis
protistans1245203protistans
protists10313363protists
protiums1238563protiums
proton84318893prot_on_
protozoans2155533protozoans
protract12510603protract
protracts1347023protracts
protrade1148213protrade
protyles13249833protyles
protyls12298463prot_yls
proven114314773prove_n_
proverbs15315583proverbs
provers123817793prove_rs
proves114322253prove__s
prowess1237903prowe_ss
puritans1037633purit_ans
pyrogens1437293pyroge_ns
ratans63819373_rat_ans
rattans73411953_rattans
reteams9339563_reteams
retears72814923_retears
roans54926443_ro__ans
romans84620243_ro_mans
rotas54827723_rot_a_s
rotes56143903_rote__s
rouens64814443_roue_ns
rowans95715343_ro_wans
rowens94515303_rowe_ns
urethans1145243urethans

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 Limit1461621647.62619166.3
3Display Results1641640.0632603.2
 (SQL Overall)1786911648.12521992.7
 
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.