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

61 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
teughly1444343(None) 
toughly14487431toughly
roughly14507292roughly
tenthly1335742tenthly
teugh95511612teugh__
toughy135911072tough_y
deathly14336863deathly
doughty15436023doughty
doughy14499843dough_y
edgily1136063_edgily
eighty133711603_eighty
haughty17334643haughty
heugh125410923heugh__
heughs13516903heugh_s
highly1636823_highly
hugely1336803_hugely
lushly12247343_lushly
muchly1686203_muchly
muhly1358523_mu_hly
naughty14445623naughty
paughty16294323paughty
plushly15385383plushly
roughy137010853rough_y
saughy13507463saugh_y
smugly1274833smug_ly
snugly1055663snug_ly
tangly104413913tang_ly
taught104312223taugh_t
tautly9499503tau_tly
tearily10311153tearily
techily1537123techily
techy135612013te_ch_y
telly84920823te__lly
tenably122210453tenably
tensely1037363tensely
tepidly1334413tepidly
tergal72912833tergal_
termly1138433te_rmly
tersely1038113tersely
testily102910803testily
tetchily1644123tetchily
tetchy1436003tetch_y
teuch105214853teuch__
thegnly1442613thegnly
throughly1952433throughly
thusly1235133thu_sly
tightly14327613t_ightly
tingly103815973ting_ly
touchily1645233touchily
touchy145010503touch_y
tough97321983tough__
toughed123511693toughed
toughen11329203toughen
tougher114210983tougher
toughie1187593toughie
toughs105414983tough_s
trigly103810943trig_ly
truly84111553tru__ly
tushy114212993t_ush_y
ugly86012383__ug_ly
weighty17376233weighty

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit134027615.84322938.0
3Display Results61610.0163812.5
 (SQL Overall)178691616.26528522.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.