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 “pitchmen” 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
pitchmen174433(None) 
pitchman1744021pitchman
bitchen14349732bitch_en
dutchmen1643162dutchmen
kitchen16287682kitch_en
pitched153512922pitch_ed
pitcher143813712pitch_er
pitches143617752pitch_es
pitchier15368272pitchier
pitchwomen2252792pitchwomen
pitmen102510792pit__men
switchmen1962422switchmen
watchmen1844752watchmen
aitches123014363aitch_es
birchen14347883birch_en
bitched153212923bitch_ed
bitches144117063bitch_es
bitchier15307733bitchier
bitumen1134503bit_umen
catchment1846293catchment
cithren12306593cit_hren
coachmen1745013coachmen
ditched143711903ditch_ed
ditcher134012003ditch_er
ditches133215713ditch_es
dutchman1643013dutchman
fitchee152710783fitch_ee
fitches153516193fitch_es
fitchet153113563fitch_et
fitchew18276803fitch_ew
hatchment1945313hatchment
henchmen1844463henchmen
hitched163312253hitch_ed
hitcher153712003hitch_er
hitches153616273hitch_es
hitmen11239193hit__men
icemen1037893_i_cemen
itched123812023_itch_ed
itches114916213_itch_es
itchier12247673_itchier
kitchens17195783kitch_ens
lichen114012743li_ch_en
nitchie1247233nitchie_
nitchies1339073nitchies
packmen1746313p_ackmen
parchment1846913parchment
patched153514623patch_ed
patcher143515143patch_er
patches143320383patch_es
patchier15319673patchier
pikemen1535333pi_kemen
pinched153812453pinch_ed
pincher143812713pinch_er
pinches144117943pinch_es
pitch125018413pitch___
pitchers153211483pitchers
pitchiest1646703pitchiest
pitchily1855013pitchily
pitching163411113pitching
pitchout1546943pitchout
pitchwoman2252363pitchwoman
pitchy16479673pitch__y
pithed124615613pit_h_ed
pithier123010293pit_hier
pitman102412123pit__man
pivotmen1542653pivotmen
placemen1445793placemen
potheen12257893pot_heen
potmen102713093pot__men
putamen1135923put_amen
ranchmen1545833ranchmen
richen113812513ri_ch_en
stickmen1634543stickmen
switchman1962203switchman
titmen8239883tit__men
watchman1844623watchman
witched163012193witch_ed
witches152715793witch_es
witchier16307883witchier

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.440406115.9
2DLD Change Limit146162796.75021653.6
3Display Results79790.0302633.3
 (SQL Overall)178691797.22024749.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.