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

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

65 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
misperceptions226248(None) 
misperception2162871misperception_
apperceptions1893033_apperceptions
interceptions1758183_interceptions
misconceptions2263573misconceptions
perceptions1798193___perceptions
apperception1793464_apperception_
imperfections2254004_imperfections
interception1649394_interception_
miscaptions1744184mis___captions
misconception2163994misconception_
miscreations1647064mis_cr_eations
misdescriptions22111964misdescriptions
misdirections1854234misdir_ections
misperceives21142024misperce__ives
misperceiving2371444misperceivi_ng
perception1688614___perception_
bisections14136735bis_e_c__tions
deceptions1547865___de_ceptions
desperations1559525desper__ations
discretions1447225dis_cr_e_tions
dispensations1655485dispe_nsations
dispersions1446455disper___sions
disruptions14125685dis__r_uptions
dissections14198265disse_c__tions
dissertations1465895disser_tations
exceptions2146865____exceptions
imperceptible23102295_imperceptible
imperceptibly26132025_imperceptibly
imperceptive2352945_impercepti_ve
imperfection2154045_imperfection_
imprecations1846275_imprec_ations
inceptions1448535_i___nceptions
inspections1546425inspe_c__tions
intercepting1748875_intercepti_ng
interceptors16115735_intercept_ors
intercessions15225885_intercessions
interjections2277995_interjections
interruptions1565735_interruptions
intersections1598965_intersections
interventions1657515_interventions
midsections1644405midse_c__tions
misassumptions2061365misassumptions
miscaption1644765mis___caption_
miscegenations1963025miscegenations
misconnections2063815misconnections
miscorrelations1963005miscorrelations
miscreation1547725mis_cr_eation_
misdescription21112125misdescription_
misdirection1754165misdir_ection_
miseducations18113295mis_educations
misfunctions1953715misfunc__tions
mislocations16145655mis_loc_ations
misperceive20142395misperce__i_ve
misperceived22141785misperce__ived
mispositions1655305misp__ositions
misprisions1553155misp_r__isions
perceptional1854905___perceptional
perfections1848145___perfections
permeations1549885___permeations
receptions1449745___re_ceptions
secretions12117855__s_ecre_tions
speciations1548485__spe_ciations
subreptions1545885__subr_eptions
superventions18125785_superventions

Search took 7 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.360496363.9
2DLD Change Limit95024656.43614764.4
3Display Results65650.0461413.0
 (SQL Overall)178691656.84226116.8
 
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.