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

81 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
nonconsumptions218227(None) 
nonconsumption20112481nonconsumption_
consumptions1845143___consumptions
nonconsumptive2372383nonconsumpti_ve
consumption1745424___consumption_
nonconduction1884474noncondu_ction_
nonconnections1894144noncon_nections
nonconsuming1753214nonconsum__i_ng
consummations1955155___consummations
consumptives2153115___consumptives
incorruptions1753265_incorru_ptions
nonconclusions1862215noncon_clusions
nonconducting1963585noncondu_cti_ng
nonconductors1873275noncondu_ct_ors
nonconnection1784415noncon_nection_
nonconscious1663735noncons___cious
nonconservation2063095nonconservation_
nonconstruction1983275nonconstruction_
nonconsumers1653025nonconsum___ers
noncooperations1963175noncooperations
noncorrelations17122825noncorrelations
nonsolutions1254175nonso_lu__tions
overconsumption24111205overconsumption_
assumptions1562736____assumptions
commensurations21182586commensurations
concentrations1877076concen_trations
conceptions17410596___con_ceptions
concoctions1448266conco____ctions
condensations1646276condens__ations
condonations1548006condon___ations
conductions1649666___condu_ctions
conformations2046726confo__rmations
confutations1767796___confutations
conjugations2245866___conjugations
conjunctions2345386___conjunctions
conjurations2148496___conjurations
conniptions1546036___con_niptions
conscriptions1955006___conscriptions
consecutions1647056___consecutions
consolations1449746___consolations
constipations1747686___constipations
consultations1546936___consultations
consummation1855296___consummation_
consumptive2054226___consumpti_ve
continuations1547156contin_u_ations
contraptions1647646___contraptions
convolutions1745196convo_lu__tions
corruptions1555176___corru_ptions
disconsolations1863206disconsolations
encapsulations1851996_encapsulations
incorruption1653356_incorru_ption_
locomotions1552186lo_co___motions
misassumptions2061366_misassumptions
misconceptions2263586miscon_ceptions
noncelebrations19122826noncelebrations
noncompetition2062876noncompetition_
noncompetitors2071996nonco___mpetitors
nonconclusion1762396noncon_clusion_
nonconcurring1872586nonconcu_rri_ng
nonconditioned1862686noncon__ditioned
nonconductive2164646noncondu_cti_ve
nonconductor1783566noncondu_ct_o_r
nonconflicting2261926nonconflicti_ng
nonconformities2273066nonconformiti_es
nonconsecutive2173026nonconsecuti_ve
nonconstant1355876noncons___t_ant
nonconsumer1553256nonconsum____er
noncontagious1662556noncon__tagious
nonconventional20102596noncon_ventional
noncooperation1863706noncooperation_
noncorrelation16113086noncorrelation_
noncultivations20182756noncultivations
nondisjunctions25101126nondisjunctions
noninformations2073136noninformations
nonpossessions15111906nonpo_ssessions
nonsolution1154746nonso_lu__tion_
preconceptions2253886precon_ceptions
presumptions18153886___presumptions
reconceptions1965126_recon_ceptions
resumptions15154596____resumptions
subsumptions1852616___subsumptions

Search took 8 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.343520965.0
2DLD Change Limit95024816.87613819.7
3Display Results81810.0631285.7
 (SQL Overall)178691817.28224538.7
 
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.