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

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

182 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
contraptions164764(None) 
contractions16410401contractions
contraption1548101contraption_
contraceptions2053382contraceptions
contraction15411242contraction_
contritions13410912contr_itions
castrations13410053castra_tions
colorations13911893colora_tions
conations111318903con__a_tions
conceptions17410593con_ceptions
concretions1549293concr_etions
conflations16411143confla_tions
conjurations2148493conjura_tions
connations12312943con_na_tions
conniptions1546033con_niptions
conscriptions1955003conscriptions
constipations1747683constipations
constrictions1747783constrictions
constructions1747713constructions
consumptions1845143consumptions
contagions1346603cont_a_gions
contentions13412093cont_entions
contortions1348683cont_ortions
contraception1953753contraception_
contracting16610473contracti_ng
contractional1756063contractional
contractors1549163contract_ors
contradictions1954143contradictions
contraltos1246763contralt_o_s
contrapositions1992423contrapositions
contrarians1346353contra_rians
contrarious1354733contra_rious
contrasting1459353contrasti_ng
contraventions19103573contraventions
contributions1754743contributions
contrition12411413contr_ition_
conurbations1646663conurbations
corruptions1555173co_rruptions
counteractions1855023counteractions
abstractions1645784abstractions
attractions1376404_attractions
captions123813224c____aptions
castration12410804castra_tion_
citations11312504c_it_a_tions
coactions1349744co___actions
coaptations1547544coapta_tions
codirections1744704codirections
cogenerations1655914cogenera_tions
cogitations1448904cogita_tions
cognations1339594co_gna_tions
collations12312854co_lla_tions
coloration12913184colora_tion_
compactions1946544co_mpactions
conation101420884con__a_tion_
concentrations1877074concentra_tions
conception16410454con_ception_
concoctions1448254con_coctions
concretion1449294concr_etion_
conditions13410104con__ditions
condonations1548004condonations
conductions1649664con_ductions
confections18411394con_fections
confirmations2055674confirmations
conflation15412084confla_tion_
conflictions1945224conflictions
conformations2046724conformations
confutations1767794confutations
congelations1549734congelations
congestions1449314con_gestions
congregations17186414congregations
conjugations2245864conjugations
conjunctions2345384conjunctions
conjuration2049514conjura_tion_
connation11314264con_na_tion_
connections15410704con_nections
conniption1446274con_niption_
connotations1447284connotations
conscription1855334conscription_
consecrations1749214consecra_tions
consecutions1647054consecutions
conservations1849094conservations
consolations1449744consolations
conspirations1747724conspira_tions
consternations16116044consternations
constipation1648564constipation_
constitutions1554864constitutions
constrains1249724constra__i_ns
constriction1648264constriction_
construction1648084construction_
consumption1745424consumption_
contacting15610074cont_acti_ng
contactors1448844cont_act_ors
contagion1246994cont_a_gion_
contagious1345354cont_a_gious
contains10316534cont_a__i_ns
contemplations2074734contemplations
contemptuous1852054contemptuous
contention12412224cont_ention_
contentious1347014cont_entious
contestations1547734contestations
continuations1547144continuations
contortion1248664cont_ortion_
contraceptives2362144contraceptives
contractible1854664contractible
contractile1547354contracti_le
contractionary2162714contractionary
contractive1849524contracti_ve
contractor1449074contract_o_r
contracts132212014contract___s
contractures1676044contractures
contradiction1854564contradiction_
contradictious1962504contradictious
contradicts1654584contra_dicts
contrails11410544contra__i_ls
contralti1147744contralti___
contralto1147094contralt_o__
contraposition18112824contraposition_
contrapuntists1871844contrapuntists
contrarian1247934contra_rian_
contraries12711934contra_ri_es
contrastive1647294contrasti_ve
contrasts112211044contrast___s
contravention18103874contravention_
contribution1655094contribution_
contusions1246994cont__usions
conurbation1547464conurbation_
convections18411494con_vections
conventions16410534con_ventions
conversations1847454conversations
convictions1848044con_victions
convocations1947364convocations
convolutions1745194convolutions
cooperations1659194coopera_tions
cooptions13107764co___options
copulations151111114copula_tions
coronations13410704corona_tions
corotations1349764corota_tions
corporations16129484corpora_tions
corrasions1246354co_rra_sions
corrections1548864co_rrections
corruption1455374co_rruption_
counteraction1755384counteraction_
covariations1745984covariations
cunctations1576154cuncta_tions
dentations11413634dent_a_tions
detractions14118274_detractions
distractions1548754distractions
donations101112354don__a_tions
dotations101411634do_t_a_tions
encryptions1852964_encryptions
entropions12105744_entrop_ions
exonerations1947014exonera_tions
extractions2077744_extractions
filtrations1445624filtra_tions
generations12311424genera_tions
infractions1646964_infractions
interactions14410464_interactions
ionizations2049894ioniza_tions
lustrations1147624lustra_tions
mentations12312584ment_a_tions
moderations1448274modera_tions
nitrations10312034_nitra_tions
nonactions1248374non__actions
notations91512974no_t_a_tions
obturations13116424_obtura_tions
operations12312954_opera_tions
orations81515804_o__ra_tions
overactions1648214_overactions
penetrations1448854penetra_tions
potations111615074po_t_a_tions
prostrations1449764prostra_tions
protractions1646644protractions
retractions13910354_retractions
rotations91613844ro_t_a_tions
sonications1349954sonica_tions
sorptions1137124so__r_ptions
subtractions1645374subtractions
titrations1039174_titra_tions
tolerations1158134tolera_tions
tractions11511624___tractions
venerations14411314venera_tions
zonations18139314zon__a_tions

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901826.90618069.8
3Display Results1821820.1101654.5
 (SQL Overall)1786911827.40624127.9
 
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.