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

68 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
conclusionary206210(None) 
concessionary2072932concessionary
convulsionary21101892convulsionary
conclusion1445223conclusion___
conclusions1544883conclusion__s
conclusory1752263conclus_o__ry
concretionary2062863concretionary
exclusionary2462243_exclusionary
coevolutionary22102384coevolutionary
concessionaire18142434concessionaire
concessional16195394concessiona_l
concessioner1653674concessioner_
concessioners1753064concessioners
conclusively2252524conclusi_vely
confectionary2353774confectionary
confusional1654244con_fusiona_l
delusionary1552504__delusionary
illusionary1452614__illusionary
nonculinary1653054nonc_uli_nary
ablutionary1652275__ablutionary
cautionary1553925___cautionary
collisional1353335co_llisiona_l
collisionally1862115co_llisionally
collusion1146415co_llusion___
collusions1245975co_llusion__s
conceptional1856915conceptiona_l
concession14148135concession___
concessionaires19171945concessionaires
concessions15128105concession__s
concision1348495conc_ision___
concisions1448245conc_ision__s
concluding1644915concludi_n__g
conclusive1744205conclusi___ve
conclusiveness2162955conclusiveness
concubinage1851825conc_ubi_nage
concussion14155575concussion___
concussions15125325concussion__s
confectionery2362565confectionery
confessional17175465confessiona_l
confessionally22103515confessionally
confessionals18154175confessionals
confusingly2052695con_fusi_ngly
confusion1446475con_fusion___
confusions1546305con_fusion__s
conglutinate15113095congluti_nate
contractionary2162715contractionary
contusion1147065con_tusion___
contusions1246995con_tusion__s
conversional1755145conversiona_l
convulsion1544435convulsion___
convulsions1644315convulsion__s
cotyledonary217855cotyl_edonary
cousinry1343535co___usi_n_ry
devolutionary2062985devolutionary
elocutionary1762375eloc_utionary
evolutionary1853325_evolutionary
functionary1953755func__tionary
inclusion11166215_inclusion___
inclusions1275655_inclusion__s
inflationary1852745_inflationary
nonstationary1672135nonstationary
occlusion1343975_occlusion___
occlusions1443715_occlusion__s
pensionary1554365pen___sionary
precautionary2062265precautionary
recessionary1753065_recessionary
revolutionary1963495revolutionary
uncustomary1861165_unc_ustomary

Search took 10 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.393454684.5
2DLD Change Limit124790688.87314064.0
3Display Results68680.0461478.3
 (SQL Overall)178691689.31219189.3
 
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.