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

109 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
constrictions174778(None) 
constriction1648261constriction_
constructions1747711constructions
conscriptions1955002conscriptions
constricting1747022constricti_ng
constrictors1676012constrict_ors
construction1648082construction_
contractions16410402con_tractions
contritions13410912con_tri_tions
conflictions1945223con_flictions
conscription1855333conscription_
conservations1849093conservations
consociations1747513consociations
conspirations1747723conspirations
consternations16116043consternations
constipations1747683constipations
constitutions1554863constitutions
constrictive1956623constricti_ve
constrictor1596123constrict_o_r
constricts1477733constrict___s
constructing1746753constructi_ng
constructional1854763constructional
constructionist1984033constructionist
constructors1676473construct_ors
contraction15411243con_traction_
contradictions1954143con_tradictions
contraptions1647643con_traptions
contributions1754743con_tributions
contrition12411413con_tri_tion_
convictions1848043con__victions
deconstructions20124363deconstructions
instructions14137813_instructions
obstructions16155523_obstructions
reconstructions19124733reconstructions
restrictions1449283_restrictions
strictions1249143___strictions
abstractions1645784_abstractions
castrations13410054c_astr_ations
codirections1744704co_directions
conciliations1747204conciliations
concoctions1448254con__coctions
concretions1549294con_cr_etions
conditions13410104con__di_tions
conductions1649664con__ductions
confections18411394con__fections
confirmations2055674confirmations
confliction1845234con_fliction_
conformations2046724conformations
conjunctions2345384con_junctions
conjurations2148494conjur_ations
connections15410704con__nections
conniptions1546034con__niptions
conscripting1954024conscripti_ng
consecrations1749214consecrations
consecutions1647054cons_ecutions
conservation1749404conservation_
consignations16105934consignations
consociation1648194consociation_
consolations1449744cons_olations
consolidations1754744consolidations
conspiration1648384conspiration_
constellations1654404constellations
consternation15106364consternation_
constipation1648564constipation_
constitution1455264constitution_
constrains1249724constr__ai_ns
constrict13711624constrict____
constricted1646364constrict__ed
constringing1653564constringi_ng
constructible19113764constructible
constructive1957444constructi_ve
constructivism23213684constructivism
constructivist21214194constructivist
constructor1576524construct_o_r
constructs1457054construct___s
consultations1546934consultations
consummations1955154consummations
consumptions1845144cons_umptions
contentions13412094con_t_entions
contortions1348684con_t_ortions
contraceptions2053384con_traceptions
contracting16610474con_tracti_ng
contractional1756064con_tractional
contractors1549164con_tract_ors
contradiction1854564con_tradiction_
contradictious1962504con_tradictious
contraption1548104con_traption_
contribution1655094con_tribution_
conurbations1646664con_urbations
convections18411494con__vections
conversations1847454conversations
conviction1748184con__viction_
corrections1548864co__rrections
counteractions1855024counteractions
covariations1745984co_variations
deconstruction19134434deconstruction_
destructions1547254_destructions
distractions1548754_distractions
inscriptions1654504_inscriptions
instruction13137944_instruction_
menstruations1585054menstruations
nonfictions1645934non__fictions
nutritions1066514__nutri_tions
obstruction15135544_obstruction_
reconstruction1894774reconstruction_
restriction1349364_restriction_
stictions1148354___st_ictions
striations10312794___striations
striction1148984___striction_

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 Limit950241094.75020005.1
3Display Results1091090.0801362.5
 (SQL Overall)1786911095.20634324.0
 
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.