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

106 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
contraventions1910357(None) 
contravention18103871contravention_
contraceptions2053382contraceptions
contentions13412093cont___entions
contraception1953753contraception_
contractions16410403contra__ctions
contradictions1954143contradictions
contraptions1647643contra__ptions
contravening1853563contraven_i_ng
conventions16410533con___ventions
concatenations1873724con_catenations
concretions1549294concr__e_tions
contaminations1886104cont_aminations
contention12412224cont___ention_
contentious1347014cont___entious
contraceptives2362144contraceptives
contraction15411244contra__ction_
contradiction1854564contradiction_
contradictious1962504contradictious
contrapositions1992424contrapositions
contraption1548104contra__ption_
contrapuntists1871844contrapuntists
contraveners1753504contraven__ers
contravenes1655634contraven___es
contributions1754744contr_ibutions
contritions13410914contr___itions
controverting1953364controverti_ng
convections18411494con___vections
convention15410564con___vention_
interventions1657514_interventions
castrations13410055castra___tions
centralizations26157785centralizations
circumventions2362945circumventions
codirections1744705codir__ections
colorations13911895colora___tions
comprehensions2362665comprehensions
conations111318905con__a___tions
concatenation1764095con_catenation_
conceptions17410595con___ceptions
concretion1449295concr__e_tion_
condescensions1981585condescensions
confections18411395con___fections
conflagrations2052725conflagrations
conflations16411145confla___tions
confrontations1962785confrontations
congestions1449315con___gestions
congratulations1882785congratulations
congregations17186415congr_egations
conjurations2148495conjura___tions
connations12312945con_na___tions
connections15410705con___nections
conscientious17102255con_scientious
conservations1849095conserv_ations
constrictions1747785constr__ictions
constructions1747715constr__uctions
contagions1346605cont_a___gions
contamination1766955cont_amination_
contemplations2074735contemplations
contenting13313325cont___enti_ng
contestations1547735cont_estations
continuations1547145cont_inuations
contortions1348685cont___ortions
contrabandists1971465contrabandists
contrabassoons187875contrabassoons
contraceptive2253005contracepti_ve
contracting16610475contra__cti_ng
contractional1756065contra__ctional
contractors1549165contra__ct_ors
contradicting1954075contradicti_ng
contradictors1883635contradict_ors
contraltos1246765contra__lt_o_s
contraposition18112825contraposition_
contrapuntist1762765contrapunti_st
contrarians1346355contra___rians
contrarieties1563815contrarieti_es
contrarious1354735contra___rious
contrasting1459355contra__sti_ng
contravene1545095contrave____ne
contravened1753555contraven___ed
contravener1653425contraven___er
contribution1655095contr_ibution_
contrition12411415contr___ition_
controversies1863345controversi_es
controverters1852465controvert_ers
controvertible21101835controvertible
controverts1654265controvert___s
conurbations1646665conur__bations
convection17411125con___vection_
conventing16311545con___venti_ng
conventional1757165con___ventional
conversions1648275con___versions
convictions1848045con___victions
corrections1548865co__r_rections
counteractions1855025countera__ctions
extraversions2382335_extraversions
intentions10411405_int___entions
intervention1568385_intervention_
intravenous1452925_intraven__ous
introjections2255785_introjections
introversions1663695_introversions
inventions1348315_in___ventions
overattentions17103185_overattentions
preventions1648535___preventions
superventions18125785super_ventions
trabeations1345375___trabeations
trajections2044515___trajections

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.360496363.9
2DLD Change Limit950241067.12313340.4
3Display Results1061060.0801325.0
 (SQL Overall)1786911067.56323627.0
 
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.