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

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

107 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
sockman153566(None) 
sockmen1535451sockmen
socman1039811soc_man
stockman1644141stockman
bookman15136482bookman
hackman1836432hackman
packman1736692packman
socmen1039192soc_men
sokeman1337262sokeman
soman75024902so__man
stickman1643942stickman
stockmen1643922stockmen
workman1635612workman
boatman1147053boatman
bogyman1544933bogyman
bondman1238043bondman
bookmen15126263bookmen
bowman13129853bo_wman
coachman1744983coachman
cocomat13413623cocomat
cowman13910373co_wman
decuman1236573decuman
deskman1444323deskman
dockhand1953393dockhand
dockland1643713dockland
dolman95312403do_lman
doorman1037063doorman
foeman11311233fo_eman
footman1236403footman
foreman12312363foreman
goodman1135933goodman
hackmen1836713hackmen
iceman1037853_iceman
junkman2043173junkman
kirkman1243773kirkman
linkman1335393linkman
lochan1139093loc_han
lockjaw2341823lockjaw
lockram1544913lockram
milkman1544913milkman
nonman8412363no_nman
ocean71212963_oc_ean
octan71313483_oc_tan
oilman839483_oilman
outman83115033_outman
packmen1746313packmen
pockmark1743403pockmark
postman112410043postman
potman102813573po_tman
rockoon1345653rockoon
rodman949713ro_dman
rodsman1036653rodsman
roman75424823ro__man
sagaman10117563sagaman
sandman10310173sandman
scan65530453s_c__an
seaman84015903s_eaman
seedman1037373seedman
shaman113314283s_haman
shipman14247133shipman
shopman14247263shopman
showman15257293showman
siccan1037593sic_can
sickbay1843723sickbay
sicken124615253sick_en
sideman1037973sideman
skean94415623s__kean
skyman1535313s_kyman
snowman12226623snowman
soca66330053soc__a_
socas74026183soc__as
social8813333soc_ial
sock105233213sock___
socked134721503sock_ed
socket123923523sock_et
sockets134012983sockets
sockeye1666413sockeye
socking143518603socking
socko115215113sock__o
socks114926083sock__s
sokemen1337053sokemen
solan55328153so__lan
soldan73511853so_ldan
solemn838643solem_n
soma65635293so__ma_
somans84619303so__mans
somas76030373so__mas
sonarman1045563sonarman
soudan73210353so_udan
soundman1144713soundman
sovran937153so_vran
soybean1243953soybean
spaceman1445323spaceman
stickmen1634543stickmen
stockcar1642923stockcar
surfman1236203surfman
swagman1334913swagman
swordman1443403swordman
tollman935863tollman
toman75724053to__man
tongman1037573tongman
trackman1645403trackman
truckman1643153truckman
woman105818003wo__man
woodman1336313woodman
woolman1235433woolman
workmen1635933workmen

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271076.56320421.6
3Display Results1071070.0462326.1
 (SQL Overall)1786911077.01525472.7
 
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.