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

79 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
watchmen184475(None) 
watchman1844621watchman
catchment1846292catchment
dutchmen1643162dutchmen
hatchment1945312hatchment
pitchmen1744332pitchmen
ranchmen1545832ranchmen
switchmen1962422switchmen
watched163012822watch_ed
watcher153113402watch_er
watches153017372watch_es
watermen1377612watermen
acumen1049013_a_cumen
ashmen1168173_a_shmen
batched154114243batch_ed
batcher144414853batch_er
batches144019613batch_es
batmen104414303bat__men
batsmen1146883bat_smen
bitchen14349733bitch_en
catcher143115823catch_er
catches144320763catch_es
catchier15329863catchier
catchments1944453catchments
catechumen1951973catechumen
coachmen1745013coachmen
dutchman1643013dutchman
earthmen1346393earthmen
gatemen1047603gat_emen
hackmen1836713ha_ckmen
hatched163414463hatch_ed
hatchel153510753hatch_el
hatcher153314723hatch_er
hatches153420273hatch_es
hatchet153317563hatch_et
hatchments2043883hatchments
henchmen1844453henchmen
kitchen16287683kitch_en
larchen12479623larch_en
latched133914063latch_ed
latches123320123latch_es
latchet123117903latch_et
latchkey2042913latchkey
marchen143312073march_en
matched153513963match_ed
matcher143214283match_er
matches143219783match_es
packmen1746313pa_ckmen
parchment1846913parchment
patched153514623patch_ed
patcher143515143patch_er
patches143320383patch_es
patchier15319663patchier
pitchman1744013pitchman
ranchman1546043ranchman
ratches123620463ratch_es
ratchet124218333ratch_et
satchel123310303satch_el
swatches16169963swatch_es
switchman1962203switchman
watch135617063watch___
watchband2043223watchband
watchcry2142363watchcry
watchdog1842243watchdog
watchers163511793watchers
watcheye19104273watcheye
watcheyes20103743watcheyes
watchful1943753watchful
watching173011173watching
watchmaker2462613watchmaker
watchout1647003watchout
waterhen1485303waterhen
waterman1397283waterman
wauchted1753373wauchted
weighmen1743463weighmen
witched163012193witch_ed
witches152715793witch_es
witchier16307883witchier
yachtmen1842433ya_chtmen

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 Filter1786911461620.1701051123.5
2DLD Change Limit146162798.78316641.5
3Display Results79790.0302633.3
 (SQL Overall)178691798.98319892.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.