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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

134 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
apperceptions189303(None) 
apperception1793461apperception_
perceptions1798192__perceptions
apperceptive2052953appercepti_ve
appreciations1964753appreciations
interceptions1758183interceptions
misperceptions2262483misperceptions
perception1688613__perception_
altercations1446374alterc_ations
apparitions1544074appar__itions
appellations1643534appe_llations
apperceives2052804apperce__ives
apperceiving2251964apperceivi_ng
applications1846774applic_ations
apportions1446284appor___tions
appreciation1855284appreciation_
apprehensions20102464apprehensions
approbations1854244app_robations
deceptions1547864__de_ceptions
exceptions2146864___exceptions
imperfections2254004imperfections
interception1649394interception_
misperception2162874misperception_
perceptional1854904__perceptional
perfections1848144__perfections
permeations1549884__permeations
receptions1449744__re_ceptions
superventions18125784superventions
aberrations1346695a_ber_rations
abjections2145675abje_c__tions
abreactions1544195abreac__tions
abruptions1443845a__br_uptions
absorptions1544595absor__ptions
accretions1444925a_ccr_e_tions
ademptions1543385a_de__mptions
adsorptions1444165adsor__ptions
advections1645555adve_c__tions
aerations9317905a__er__ations
affectations2043435affe_ctations
affections1845895affe_c__tions
alterations11511665alter__ations
altercation1347015alterc_ation_
alternations1246775alter_nations
apparition1444585appar__ition_
appellation1564125appe_llation_
apperceive1953275apperce__i_ve
apperceived2152115apperce__ived
appertains1455275apper___tains
application1747475applic_ation_
apportion1347005appor___tion_
appositions1546155app__ositions
appreciating1954085appreciati_ng
appreciators1853515appreciat_ors
apprehension1992645apprehension_
apprentices1753565app_r_entices
approbation1755025app_robation_
arcuations1249345a___rcuations
ascriptions1544985a_scr_iptions
aspersions1246105asper___sions
aspirations1348995aspir__ations
assertions1046585asser___tions
conceptions17410595__conceptions
contraceptions2053385contraceptions
deception1448325__de_ception_
decryptions1943615__decryptions
deprecations1748565deprec_ations
depreciations1846575depreciations
erections112515215___er_ections
eruptions1146765___er_uptions
exception2046855___exception_
excerptions2244985___excerptions
expectations2365845expe_ctations
hypercautious2362675hypercautious
hypertensions2194065hypertensions
imperceptible23102295imperceptible
imperceptibly26132025imperceptibly
imperceptive2352945impercepti_ve
imperfection2154045imperfection_
imprecations1846275imprec_ations
inceptions1448535___inceptions
intercepting1748875intercepti_ng
interceptors16115735intercept_ors
intercessions15225885intercessions
interjections2277995interjections
interruptions1565735interruptions
intersections1598965intersections
interventions1657515interventions
operations12312955_oper__ations
oppressions1545725opp_r_essions
overcautions1755265_overcautions
percentiles1546205__percentiles
perceptible1953635__perceptible
perceptibly2253155__perceptibly
perceptive1946805__percepti_ve
percepts14247645__percept___s
percolations1648055__percolations
percussions1544875__percussions
perditions1348875__per_ditions
pereions10310855__per_e__ions
perfection1748365__perfection_
permeation14410565__permeation_
perorations13314065__perorations
persecutions1654795__persecutions
perversions1645415__perversions
precautions1546555_pre_cautions
preceptors1657055_pre_cept_ors
precessions1548555_pre_cessions
preconceptions2253885_preconceptions
preemptions17134855_pre_emptions
prelections151210475_pre_lections
preoptions1447645__p_reoptions
prescriptions19135335_prescriptions
presumptions18153885_presumptions
preventions1648535_pre_ventions
procreations1647275_procreations
quercetins2152595_querce_ti_ns
reception13410325__re_ception_
reconceptions1965125reconceptions
recreations13412255__recreations
repercussions1752155repercussions
secretions12117845__secre_tions
speciations1548485_spe_ciations
subreptions1545885_subr_eptions
supercautious1753925supercautious
superfetations1975065superfetations
supernations14410875super_nations
superscriptions2163345superscriptions
supersessions1454775supersessions
superstations15208145superstations
superstitions15176785superstitions
supervention17105995supervention_
unappreciations2181635unappreciations
unperceptive2163075unpercepti_ve
uppercutting1951535uppercutti_ng

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901348.08015444.3
3Display Results1341340.0761763.2
 (SQL Overall)1786911348.54620909.3
 
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.