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

44 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
thwartly174270(None) 
tartly96014022t__artly
thwart12311682thwart__
thwarted1533362thwarted
thwarter1433392thwarter
thwarts1345022thwart_s
towardly1543652towardly
athwart1348683athwart__
charily15310283ch_arily
cowardly1744093cowardly
ghastly14354563gh_astly
hardly135112833_h_ardly
heartily1436563_heartily
hearty126313633_heart_y
hoarily1338973_hoarily
inwardly1543783inwardly
partly116315473__partly
peartly1267453_peartly
sharply15406833sh_arply
shortly13387573sh_ortly
smartly12497433_smartly
stalwartly1651473stalwartly
swarthy16466373_swarthy
swarty125812383_swart_y
tartily103511573t__artily
tarty86328183t__art_y
tautly9499503t__autly
tawdrily1542733tawdrily
tearily10311153t_earily
thearchy1943443thearchy
thirdly1444633th_irdly
thirty12378403th_irt_y
thistly1395963th_istly
thrawnly1741793thrawnly
thwarters1542843thwarters
thwarting1632763thwarting
truantly1144643truantly
twattle1064273t_wattle
twirly12427083t_wir_ly
unwarily1446363unwarily
upwardly1742793upwardly
warily122915093__warily
warmly14228063__warmly
warty119323823__wart_y

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 Filter1786911461620.423422437.4
2DLD Change Limit146162447.23320207.7
3Display Results44440.0162750.0
 (SQL Overall)178691447.67223291.3
 
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.