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

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

79 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
consternation1510636(None) 
consternations16116041consternations
conservation1749402cons_ervation
constellation1554792constellation
consternating1654972consternating
concatenation1764093concate_nation
condemnation1746043con_demnation
consecration1649783cons_ecration
conservations1849093cons_ervations
consideration1655523consider_ation
consignation15136313cons_ignation
conspiration1648383conspir_ation
constellations1654403constellations
consternate1355123consternat__e
consternated1554113consternat_ed
consternates1455053consternat_es
constipation1648563const_ipation
constriction1648263const_riction
construction1648083const_ruction
contention12412223con_te_n_tion
contestation1448663con_testation
conversation1747803con_versation
alternation1147624__alternation
castration12410804c_ast_r_ation
catenation1249524c__ate_nation
coacervation1964274co_acervation
codetermination2062124codetermination
cogeneration1546444cogener_ation
concatenations1873724concate_nations
condemnations1845404con_demnations
condensation1546784con_densation
condonation1448854con__donation
confederation1995254confeder_ation
confirmation1946184con_firmation
conformation1947324con_formation
congelation14410344con_ge_lation
congregation16226764congre_gation
conjuration2049514con_jur_ation
connation11314264con____nation
conscription1855334cons_cription
consecrations1749214cons_ecrations
consecution1547304cons_e_cution
conservational1955344cons_ervational
conservatism19104954cons_ervatism
conservative20106984cons_ervative
conservatize26125494cons_ervatize
conservator1656364cons_ervat_or
considerations1764844consider_ations
consignations16105934cons_ignations
consociation1648194cons_ociation
consolation13410984cons__olation
consolidation1655154consolidation
conspirations1747724conspir_ations
constellating1653264constellating
constipations1747684const_ipations
constitution1455264const_itution
constrain1149334const_r_a_i_n
constrictions1747784const_rictions
constructions1747714const_ructions
consultation1447474cons_ultation
consummation1855294cons_ummation
contamination1766954contamination
contemplation1985264con_templation
contentions13412094con_te_n_tions
contestations1547734con_testations
continuation1448194con_tinuation
contortion1248664con_tor__tion
contraction15411244con_t_raction
contraption1548104con_t_raption
contrition12411414con_t_r_ition
conurbation1547464con__urbation
convention15410564con_ve_n_tion
conversations1847454con_versations
cooperation15410024co_oper_ation
counteraction1755384counteraction
cybernation1843914c__ybernation
menstruation1455224menst_ruation
observation1665054_obs_ervation
ostentation1146964_o_stentation

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 Filter178691950240.376475242.0
2DLD Change Limit95024794.85619568.4
3Display Results79790.0461717.4
 (SQL Overall)178691795.27833855.8
 
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.