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

73 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
prepossessions176228(None) 
prepossession1762261prepossession_
repossessions1453061_repossessions
prepossessing1862272prepossessi_ng
repossession1453072_repossession_
dispossessions1561473dispossessions
nonpossessions15111883nonpossessions
possessions1264993___possessions
prepossesses1552903prepossess__es
repossessing1553033_repossessi_ng
repossessors1361673_repossess_ors
dispossession1561514dispossession_
nonpossession1582044nonpossession_
possession1264824___possession_
precessions1548524pre___cessions
prepositions16108284prepo_s_itions
prepossess1443074preposse_s___s
prepossessed1752184prepossess__ed
processions1548144pr__o_cessions
professions1646634pr__o_fessions
progressions1555534pr__ogressions
repossesses1253334_repossess__es
repossessor1351794_repossess_o_r
repressions1348954_rep__ressions
unprepossessing207634unprepossessi_ng
depressions1447295_dep__ressions
derepressions1653065derep__ressions
dispossessing1661565dispossessi_ng
dispossessors1461005dispossess_ors
obsessions1244245____obsessions
possessing1344655___possessi_ng
possessional1463615___possessional
possessives1583145___possessives
possessors1153185___possess_ors
preadmissions1852365pre_admissions
precession1448795pre___cession_
precombustions2262045precombustions
preconceptions2253845preconceptions
predigestions1773285pre_digestions
prehensions1645935pre___hensions
preponderations20112865preponderations
preportions1548245prepo___rtions
preposition15108565prepo_s_ition_
preposterous1652565preposte__rous
preprocessing2053555preprocessi_ng
preprocessors1962485preprocess_ors
preprofessional2282035preprofessional
prerecession1683555pre_recession_
preseasons1244045pre___seas_ons
pretensions1347075pre___tensions
pretermissions1861875pretermissions
procession1448395pr__o_cession_
profession1546575pr__o_fession_
progression1455865pr__ogression_
propositions16108295propo_s_itions
reaccessions1652765_re_accessions
reassertions1253645_re_assertions
reassessing1243995_re_assessi_ng
recessions1248925_re___cessions
recommissions1953655_recommissions
reconversions1853865_reconversions
regressions1247095_re__gressions
reimpressions1753195_reimpressions
repercussions1752155_repercussions
repositions131110145_repo_s_itions
repossess1143695_reposse_s___s
repossessed1452525_repossess__ed
reprehensions1853195_reprehensions
repression1249025_rep__ression_
rescissions1344595_re__scissions
retrocessions15114345_retrocessions
retrogressions15113155_retrogressions
supersessions1454745_supersessions

Search took 8 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 Limit95024736.86013851.9
3Display Results73730.0461587.0
 (SQL Overall)178691737.03225411.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.