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

(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
watches15301737(None) 
batches144019611batches
catches144320771catches
hatches153420271hatches
latches123320121latches
matches143219781matches
patches143320381patches
ratches123620461ratches
swatches16169961swatches
watched163012821watched
watcher153113401watcher
watchers163511791watchers
witches152715791witches
aches106132292_a_ches
aitches123014362aitches
arches114822042_arches
baches135426942ba_ches
batched154114242batched
batcher144414852batcher
batchers153613272batchers
bathes116524832bat_hes
bitches144117062bitches
botches143716022botches
butches144315362butches
caches137926912ca_ches
catcher143115822catcher
catchers153114062catchers
cratches153012542cratches
cutches143216462cutches
datchas1347422datchas
ditches133215712ditches
etches114217762_etches
fetches153413892fetches
fitches153516192fitches
hatched163414462hatched
hatchel153510752hatchel
hatchels16368672hatchels
hatcher153314722hatcher
hatchers163113172hatchers
hatchet153317562hatchet
hatchets163310382hatchets
hitches153616272hitches
hotches153814362hotches
hutches153613522hutches
itches114916212_itches
ketches164012192ketches
klatches17157132klatches
laches116528342la_ches
larches124416442larches
latched133914062latched
latchet123117902latchet
latchets133410012latchets
lathes95127492lat_hes
letches124015482letches
maches134827232ma_ches
manches143818622manches
marches143921172marches
matched153513962matched
matcher143214282matcher
matchers153012432matchers
mutches143314282mutches
naches114622412na_ches
nautches1336082nautches
notches123513652notches
parches143720002parches
patched153514622patched
patcher143515142patcher
patchers153413302patchers
pitches143617752pitches
ranches123620112ranches
ratchet124218332ratchet
ratchets133110262ratchets
retches123318512retches
rotches123515702rotches
satchel123310302satchel
satchels13328162satchels
slatches131511522slatches
snatches131410712snatches
swathes134115512swat_hes
switches16159132switches
taches114224172ta_ches
thatches1637512thatches
twitches16156372twitches
vetches153411262vetches
wackes154717712wa_ckes
washes124425492wa_shes
watapes12228382watapes
watch135617062watch__
watcheye19104272watcheye
watcheyes20103742watcheyes
watchmen1844752watchmen
wattles103814072wattles
wauchts15285282wauchts
welches153710312welches
wenches152914132wenches
wiches144418752w_iches
winches154714372winches
witched163012192witched
withes124620842wit_hes
wretches16257282wretches
wyches17387912w_yches

Search took 4 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 Filter1786911076710.1261418182.5
2DLD Change Limit1076711013.31332499.5
3Display Results1011010.0303366.7
 (SQL Overall)1786911013.46951510.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.