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

48 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
contraposition1811282(None) 
contrapositions1992421contrapositions
contrapositive21122192contrapositive
contrapositives22111783contrapositives
contraption1548103contrap___tion
composition1746794co___mposition
contraception1953754contra_ception
contraction15411244contra___ction
contradiction1854564contra_diction
contraptions1647644contrap___tions
contravention18103874contra_vention
contrition12411414contr____ition
interposition1586054_interposition
juxtaposition29161694juxt_aposition
nondeposition16102904non_deposition
postposition1654794post__position
centralization25108155centralization
compositions1846255co___mpositions
congratulation1782825congratulation
contamination1766955cont_amination
contemplation1985265contemp_lation
contortion1248665cont___o_rtion
contrabassoon1771035contrabas_soon
contraceptions2053385contra_ceptions
contractions16410405contra___ctions
contradictions1954145contra_dictions
contrapuntist1762765contrap_untist
contrasting1459355contra__s_ting
contrastive1647295contra__s_tive
contraventions19103575contra_ventions
contribution1655095contr__ibution
contritions13410915contr____itions
corporation151210655co__r_poration
counterpetition1961945counterpetition
extrapolation2263665_extrapolation
indisposition1662495_indisposition
interpositions1685125_interpositions
juxtapositions30161585juxt_apositions
nondepositions17112555non_depositions
opposition1445485_o___pposition
oviposition1653595_o__viposition
postpositions1753965post__positions
preposition15108585___preposition
proposition1588745___proposition
reposition121010145____reposition
superposition17135595super_position
transition1049705___tra_nsition
transposition1554185___transposition

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.343520965.0
2DLD Change Limit95024487.08013421.5
3Display Results48480.0461043.5
 (SQL Overall)178691487.46923924.4
 
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.