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

105 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
dogwatches204221(None) 
dogcatcher1952012dogcatcher
dogcatchers2051602dogcatchers
dogwatch1841702dogwatch__
despatches1874043despatches
dethatches1943193dethatches
dispatches1874583dispatches
dogfaces1554143dogfa_c_es
dogmatizes2365493dogmatizes
dowitcher1842593do_witcher
dowitchers1942133do_witchers
hogwashes1942463hogwa_shes
midwatches2141803midwatches
outwatches1843473outwatches
potlatches17113323potlatches
stopwatches2151603stopwatches
swatches16169963__swatches
watches153017373___watches
batches144019614___batches
bewitches1943824_bewitches
birdwatches2281014birdwatches
botches143716024bo___tches
bycatches2142684_bycatches
catches144320774___catches
coaches144018694co__a_ches
cognates11311584cognat__es
cowcatcher1951724cowcatcher
cowcatchers2051564cowcatchers
cratches153012544__cratches
datchas1347424d___atchas
deathwatches246974deathwatches
debauches17124064d_ebauches
demarches1745914d_emarches
despatched1953234despatched
detaches1439654d_eta_ches
dethatched2042534dethatched
dispatched1993884dispatched
dispatcher1853264dispatcher
dispatchers1972464dispatchers
ditches133215714d___itches
dogbanes1245434dogba__nes
dogface1454054dogfa_c_e_
dogfishes1745084dog_fishes
dogmatics1544884dogmat_ics
dogmatisms1643944dogmatisms
dogmatists1443814dogmatists
dogmatize2265764dogmatize_
dogmatized2454854dogmatized
dogmatizer2344114dogmatizer
dogmatizers2452584dogmatizers
dogvanes1344304dogva__nes
donates83217224do_nat__es
donatives13146904do_natives
dormancies1565414dormancies
douches134315234do___uches
downtimes1544514do_wntimes
downwashes2051764downwa_shes
enswathes1543434enswat_hes
frogmarches2251144frogmarches
glitches14296664__glitches
gouaches1436204go_ua_ches
grutches14285854__grutches
hatches153420274___hatches
hootches1656974ho__otches
hotches153814364ho___tches
inswathes1543954inswat_hes
klatches17157144__klatches
latches123320134___latches
loaches123613984lo__a_ches
loathes103513244lo__at_hes
matches143219784___matches
mismatches1953754mismatches
mispatches1974104mispatches
moustaches1763814moustaches
notches123513654no___tches
nuthatches1842394nuthatches
oraches124216474_o_ra_ches
outcatches1743784outcatches
outmatches1763744outmatches
outwatched1943424outwatched
overwatches2243484overwatches
patches143320384___patches
poaches144416944po__a_ches
potlaches16115264potla_ches
potlatched18112454potlatched
ratches123620464___ratches
rematches1636654_rematches
repatches1636714_repatches
roaches123616214ro__a_ches
rotches123515704ro___tches
scratches1647324_scratches
slatches131511534__slatches
snatches131410714__snatches
soutaches1446444souta_ches
swathes134115514__swat_hes
switches16159134__switches
thatches1637514__thatches
twitches16156374__twitches
unlatches1444304_unlatches
unswathes1544214unswat_hes
unwatched1844084_unwatched
watched163012824___watched
watcher153113404___watcher
watchers163511794___watchers
witches152715794___witches

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 Filter1786911614500.466383457.1
2DLD Change Limit1614501059.31317336.0
3Display Results1051050.0631666.7
 (SQL Overall)1786911059.84218156.0
 
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.