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

43 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
nonbreathing185210(None) 
inbreathing1742802_inbreathing
breathing15218373___breathing
enwreathing1842123_enwreathing
nonbearing1346453nonb_ea_ring
nonbetting1345843nonb_e_tting
nonbreeding1553323nonbre_eding
nonreading1246883non_rea_ding
nonteaching1753583non_teaching
unwreathing1842803_unwreathing
breaching17269404___breaching
breathings16234314___breathings
cocreating15310294co_creat_ing
concreting1539874concre_t_ing
congregating1754284congregat_ing
ensheathing18102564_ensheathing
entreating11811554_entreat_ing
forereaching2151954forereaching
insheathing18102694_insheathing
intreating11614014_intreat_ing
nonbanking1743734nonb__anking
nonbeing1137054nonb_e___ing
nonbiting1247824nonb__it_ing
noncreative1648234noncreat_ive
nonearning1145184non__earning
nonfreezing2452384nonfre_ezing
nonmeeting1346074non_meet_ing
nonoperating1555414nonoperat_ing
nonreducing1553174non_reducing
nonrioting1146754non_riot_ing
nonrotating1246304non_rotating
nonspeaking1853194nonspea_king
nonthreatening1861084nonthreatening
nontreatment1454134nontreatment
northing12199064no__r__thing
outreaching1744914_outreaching
overbreathing22173674overbreathing
overeating141016534_overeat_ing
sunbathing1642934sunb__athing
unbreeching1942164_unbreeching
uncreating13310474_uncreat_ing
unsheathing1892984_unsheathing
wreathing16266314___wreathing

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.406440125.6
2DLD Change Limit124790437.90615784.2
3Display Results43430.0162687.5
 (SQL Overall)178691438.32821456.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.