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 “proprioceptionsa” with Change Limit: [1] [2] [3] [4] [5] [6] [7] [8]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
proprioceptions2091801proprioceptions_
proprioception19111992proprioception__
proprioceptors1971833propriocept_ors_
proprioceptive2291434propriocepti__ve
proprioceptor1871704propriocept_o__r
perceptions1798196p__er__ceptions_
photoreceptions2473356photoreceptions_
preconceptions2253886pr_econceptions_
preproductions2153946prepr_oductions_
procreations1647276procr___eations_
propitiations1756206prop_i_tiations_
proportions1548466prop__o__rtions_
propositions16108316prop__o_sitions_
proprieties1556186propri__e_ti_es_
proprietors1554386propri__e_t_ors_
prorogations1556726pro_r_o_gations_
proscriptions19114166proscri___ptions_
protractions1646646protr_ac__tions_
provocations1956876pro__voc_ations_
apperceptions1893037__apperceptions_
appropriations1763177appropri___ations_
conceptions17410597_co___nceptions_
contraceptions2053387_contraceptions_
coproductions2054497_copr_oductions_
expropriations2553327expropri___ations_
inceptions1448537_____inceptions_
interceptions1758187inter__ceptions_
misperceptions2262487misp_erceptions_
perception1688617p__er__ception__
perceptional1854907p__er__ceptional
photoreception2373787photoreception__
postconception2282457p_ostconception__
preconception2154287pr_econception__
predications17411187pr_edi_c_ations_
predictions1649657pr_edi_c__tions_
predigestions1773287pr_edi_gestions_
predilections1853567pr_edi_lections_
preoptions1447647___preo__ptions_
preportions1548267prep__o__rtions_
prepositions16108307prep__o_sitions_
preprocessing2053557prepr_ocessi_n_g
preprocessors1962487prepr_oce_ssors_
preproduction2054397prepr_oduction__
preprofessional2282037prepr_ofessional
prescriptions19135337prescri___ptions_
prevarications2154747prevari_c_ations_
prioritizations26123857prioritizations_
proactions1449347pro___ac__tions_
processions1548157___pr_ocessions_
procreation1547957procr___eation__
productions1647537pro__duc__tions_
progressions1555557progr___essions_
prohibitions1953837pro_hi__bitions_
projections2258477___pr_ojections_
proliferations1952707pro_liferations_
prolongations1673357pro__longations_
promotions1448787pro__mo___tions_
pronunciations18122787pro_nunciations_
propagations1745557prop___agations_
propitiation1656917prop_i_tiation__
propitious1446607prop_i____tious_
proportion1448997prop__o__rtion__
proportional1655817prop__o__rtional
proportioned1754407prop__o__rtioned
proposition1588747prop__o_sition__
propositional1755247prop__o_sitional
propositioned1853917prop__o_sitioned
propraetors1554187propr__ae_t_ors_
propretors1445797propr___e_t_ors_
proprietor1454487propri__e_t_o__r
proprietorial1762397propri__e_t_orial
proprietress1651817propri__e_t_ress
prorations12314467pro_r____ations_
prorogation1447397pro_r_o_gation__
proscription18124517proscri___ption__
prosecutions1645617pro__sec_utions_
prostitutions1554257prosti__tutions_
protections15510707___pr_otections_
protonations1449077pro__to_nations_
protraction1547217protr_ac__tion__
protreptics1753477protr___epti_cs_
provocation1847357pro__voc_ation__
receptions1449747____r_eceptions_
reconceptions1965127_r_econceptions_
replications16811057_repli_c_ations_
reprobations1647777_repr_o_bations_
reproductions1865277_repr_oductions_
retrocessions15114357_retr_ocessions_
rubrications1646267_rubri_c_ations_
triplications1795077tripli_c_ations_

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 Filter178691950240.1261418182.5
2DLD Change Limit95024908.14011673.7
3Display Results90900.0631428.6
 (SQL Overall)178691908.32921454.1
 
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.