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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

101 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
dethatching214224(None) 
despatching20122652despatching
detaching1637262det_a_ching
thatching1835142__thatching
debauching1942473de_bauching
dethatch1742753dethatch___
dethatched2042533dethatch_ed
dethatches1943193dethatch_es
detracting1438713detra_cting
dispatching20143523dispatching
hatching173312213___hatching
outcatching1943113outcatching
outmatching1943333outmatching
outwatching2043013outwatching
potlatching1952113potlatching
rematching1844913re_matching
repatching1844993re_patching
reteaching1636023retea_ching
thatchings1942483__thatchings
attaching1545434_atta_ching
batching163712094___batching
beaching164114144be__a_ching
bechancing2044444bechanc_ing
bethanking2044294betha_nking
betrothing1644674betrot_hing
bewitching2162774be_witching
catching163712774___catching
deashing134210954de__a_shing
debating123213734de_bat__ing
debouching1942724de_bouching
defacing15238684de_fa_c_ing
defatting1436104de_fat_ting
defeating142311974defeat__ing
deflating142610714deflat__ing
dehiscing1643734de_hisc_ing
delating103119604de_lat__ing
denaturing12115864de_naturing
derating103222284de_rat__ing
deratting1139514de_rat_ting
detailing112510414det_a_iling
detaining112510474det_a_ining
detecting13259984det__ecting
detesting112610324detest__ing
dethroning1544744deth_roning
deticking1736044det__icking
detonating1248824detonat__ing
detraining1267674detra_ining
deviating14311084deviat__ing
dewatering1545774de_watering
ditching15349944d___itching
enhancing1545824_enhanc_ing
etching134511844_e___tching
fetching17298414fe___tching
hatchings18225674___hatchings
hatchling1844954___hatchling
hitching173310524___hitching
hotching17309314___hotching
hutching17318644___hutching
latching143712024___latching
leaching143012834le__a_ching
letching143810264le___tching
matching163512394___matching
mismatching21123404mismatching
mispatching21133434mispatching
outbitching1992864outbitching
outmarching1943604outmarching
outpitching1962974outpitching
overmatching2353674overmatching
overwatching2453404overwatching
patching163212754___patching
peaching163613644pe__a_ching
reaching143317204re__a_ching
reattaching1743124reatta_ching
rebranching1943384rebranching
rehashing1647114re_ha_shing
researching1743424researching
resketching2142274resketching
restitching1744004restitching
restretching1852894restretching
retacking1658974ret_a_cking
retching143412174re___tching
retouching1644694ret_ouching
retracing12313294retra_c_ing
retracking1738164retra_cking
retracting13311934retra_cting
retrenching1743914retrenching
scratching1844534_scratching
searching1538344se__arching
snatching1536364__snatching
stanching1538084_st_anching
starching1538594_st_arching
stitching1547104_st_itching
stretching1645814_stretching
teaching143612604__tea_ching
thacking183110044__tha_cking
thatchier1743984__thatchier
twitching1834244__twitching
unhitching1942844_unhitching
unlatching1643154_unlatching
unteaching1645494untea_ching
watching173011174___watching

Search took 10 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 Filter1786911488190.453394461.4
2DLD Change Limit1488191019.12616307.1
3Display Results1011010.0631603.2
 (SQL Overall)1786911019.64218532.6
 
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.