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

97 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
constipating177539(None) 
constipation1648562constipation
constipations1747682constipations
constituting1554652constituting
castigating1546003c_astigating
conscripting1954023conscrip_ting
consecrating1747943consecrating
consisting1349523cons_i_sting
consociating1755573consociating
consolidating1753283consolidating
constellating1653263constellating
consternating1654973consternating
constipate1446393constipat__e
constipated1645463constipat_ed
constipates1546353constipat_es
constricting1747023constricting
constructing1746753constructing
consummating1953663consummating
instigating1347153_instigating
aestivating1545804_aestivating
busticating1645304_busticating
cantillating1565044can_tillating
captivating1944884c_aptivating
castrating1349774c_ast_rating
coassisting1443594coassi_sting
cocultivating2162344cocultivating
cogitating1447214co__gitating
colligating1545704co_lligating
collimating1645424co_llimating
complicating2145634complicating
concatenating1853264concatenating
conceiting15311774concei__ting
conciliating1775614conciliating
confiscating2053614confiscating
conflating16410004con__flating
conflicting1944724confli_cting
conglobating1853164conglobating
conglutinating1862424conglutinating
congregating1754284congregating
conjugating2244504con_jugating
consenting13313214cons__enting
considering1544844cons_idering
consigning1446784cons_i_gning
consorting13410744cons__orting
conspiration1648384conspiration
conspirations1747724conspirations
conspiring1546554cons__piring
constative15410104const__ative
constitution1455264constitution
constitutions1554864constitutions
constitutive1754104constitutive
constrain1149334const_ra_in_
constraining1554544constraining
constrains1249724const_ra_ins
constraint12411134const_ra_int
constringing1653564constringing
construing1347444const__ruing
consulting1349084cons__ulting
contacting15610074con_t_acting
contaminating1854914contaminating
contemplating2054124contemplating
contenting13313324con_t_enting
contesting13312214con_t_esting
continuing1348194con_ti_nuing
contorting13410104con_t_orting
contracting16610474con_tracting
contrasting1459354con_trasting
contributing1754304contributing
convicting1847584con_vi_cting
coordinating1653914coordinating
corotating1349324corot__ating
coscripting1843904coscrip_ting
cultivating1744944c_ultivating
dissipating1556314_dissipating
domesticating1953024domesticating
estimating1348884__estimating
estivating1447634__estivating
festinating1547374_festinating
fustigating1654054_fustigating
initiating1149624_initi_ating
instating10812214_inst__ating
instituting1244804_instituting
intimating13410824_in_timating
masticating1647834_masticating
menstruating1553864menstruating
motivating1646804mo__tivating
nonsuiting1147274nonsui__ting
postdating1447164po_st_dating
postmating1548604po_st_mating
postulating1447504po_stulating
reconstituting1763234reconstituting
reestimating1545934reestimating
rusticating1446314_rusticating
sonicating1348314son__icating
unstating10711214_unst__ating
unstinting1147304_unsti_nting
ventilating1546334ven_tilating

Search took 9 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.1531167915.0
2DLD Change Limit124790978.00015598.8
3Display Results97970.0631539.7
 (SQL Overall)178691978.21621749.1
 
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.