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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
congratulations1882781congratulations_
congratulation1782822congratulation__
congratulating1862143congratulati_n_g
congratulators1762043congratulat_ors_
confabulations2162804con_fabulations_
congratulates16103294congratulat__es_
congratulator1672124congratulat_o__r
congratulatory2061734congratulat_o_ry
gratulations1345174___gratulations_
coagulations1546515co___agulations_
concatenations1873725con_catenations_
concretizations2854035concretizations_
confabulation2063305con_fabulation__
congelations1549735cong___elations_
conglutinations1862545conglutinations_
congratulate1583195congratulat____e
congratulated17112875congratulat___ed
congregations17186415congr__egations_
degranulations1652745_degranulations_
granulations1345785___granulations_
gratulation1245995___gratulation__
ingratiations1455155_ingrat_iations_
angulations1268056_ang___ulations_
capitulations1754066c__apitulations_
centralizations26157786centralizations_
centrifugations2161486centrifugations_
circulations1648486c__ir_culations_
coagulation1447276co___agulation__
coarctations16114496co_arct__ations_
cogitations1448906co_g_it__ations_
concatenation1764096con_catenation__
concentrations1877076concent_rations_
concretization2754376concretization__
confabulating21102726con_fabulati_n_g
confabulators20142546con_fabulat_ors_
configurations2063706con_figurations_
conflagrations2052726confla_grations_
conflations16411146con____flations_
confrontations1962786confr_ontations_
confutations1767796con___futations_
congelation14410346cong___elation__
conglobations1853946cong__lobations_
conglomerations2062736conglomerations_
conglutination1762786conglutination__
congregation16226766congr__egation__
congregational1863436congr__egational
conjugations2245866con___jugations_
conjurations2148496con___jurations_
connotations1447286con_not__ations_
consolations1449746con___solations_
constellations1654406con_stellations_
constipations1747686con__stipations_
constitutions1554866constitu__tions_
consultations1546936con___sultations_
contaminations1886106con_taminations_
contemplations2074736con_templations_
contestations1547746contest__ations_
continuations1547156con_tinu_ations_
contraceptions2053386contra_ceptions_
contractions16410406contra___ctions_
contradictions1954146contra_dictions_
contrapositions1992426contrapositions_
contraptions1647646contra___ptions_
contraventions19103576contra_ventions_
contributions1754746contribu__tions_
conurbations1646666conur___bations_
copulations151111116co____pulations_
corotations1349776co__rot__ations_
correlations1447866co__r_relations_
corrugations1565486co__r_rugations_
crenulations1446496c___renulations_
degranulation1552916_degranulation__
denaturations1444956den__aturations_
dogmatizations2755446do_gmatizations_
formulations1745646fo__r_mulations_
graduations1385236___gradu_ations_
granulation1246556___granulation__
gratulating1344726___gratulati_n_g
infatuations1544436_in_fatu_ations_
ingratiation1355806_ingrat_iation__
mongrelizations2753706mongrelizations_
morulations13148166mo__r__ulations_
nonregulation1473906non_regulation__
oversaturations1863966_oversaturations_
postulations14127736po___stulations_
renaturations1355966ren__aturations_

Search took 6 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 Filter178691658740.326548131.9
2DLD Change Limit65874865.48612007.7
3Display Results86860.0601433.3
 (SQL Overall)178691865.87230431.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.