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

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

45 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
truncating134423(None) 
truncation1245452truncation
truncations1344762truncations
brunching17316483brunc_hing
coruscating1644693coruscating
crunching17297003crunc_hing
educating1337933edu_cating
enunciating1444373enunciating
eructating1345693eructating
eructing112110173eru_c_ting
furcating1537783_furcating
grunting10269583grun__ting
inundating1244543inundating
pronating12313763pron_ating
ruinating1039593_ruinating
strunting1037873strun__ting
taunting93510933taun__ting
tincting1148883t_inc_ting
trancing112812023tranc__ing
transacting1446523transacting
transiting11410773transiting
translating1249443translating
treating92519613tr__eating
trenching15227653trenc_hing
trifurcating1852143trifurcating
trinketing1544153trinketing
trouncing1235153trounc__ing
truanting1035603tru_anting
trucing103211843tru_c__ing
trucking153310163tru_c_king
truckling1645073tru_ckling
trumpeting1543573trumpeting
truncate1046283truncat__e
truncated1244583truncat_ed
truncates1145843truncat_es
trundling1135003trun_dling
trusting93411653tru__sting
uncaging1268713__uncaging
uncaking1539463__uncaking
uncaring11312843__uncaring
uncasing11511003__uncasing
uncoating12611923__uncoating
uncrating12813183__uncrating
urinating10310653urin_ating
urticating1347353urticating

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 Filter1786911406030.436409841.7
2DLD Change Limit140603456.83020586.1
3Display Results45450.0133461.5
 (SQL Overall)178691457.27924548.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.