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

170 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
sockmen153545(None) 
sockman1535661sockman
socmen1039191soc_men
stockmen1643921stockmen
bookmen15126262bookmen
hackmen1836712hackmen
packmen1746312packmen
sicken124615252sick_en
socked134721502sock_ed
socket123923522sock_et
socman1039812soc_man
sokemen1337052sokemen
stickmen1634542stickmen
stockman1644142stockman
workmen1635932workmen
acumen1049013_acumen
boatmen1146913boatmen
bogymen1534763bogymen
bondmen1237893bondmen
bookman15136483bookman
bowmen1399853bo_wmen
buckeen1536703buckeen
coachmen1745013coachmen
cocked155022563cock_ed
cocker144320393cock_er
cockier154013623cockier
cockle143913573cockle_
cockled163710823cockled
cockles153414643cockles
cockney1835873cockney
cowmen13810923co_wmen
deskmen1435023deskmen
docked145018333dock_ed
docker134417653dock_er
docket134721173dock_et
document1348663document
dolmen93911373do_lmen
doormen1036753doormen
foemen11310523fo_emen
footmen1246583footmen
foramen12310533foramen
foremen12412923foremen
goodmen1135623goodmen
hackman1836433hackman
hocked165521303hock_ed
hocker155118563hock_er
hockey184813153hock_ey
icemen1037893_icemen
jockey22408033jock_ey
junkmen2033633junkmen
kirkmen1232923kirkmen
linkmen1335363linkmen
locked134921663lock_ed
locker124019423lock_er
locket123922473lock_et
lockset13311163lockset
milkmen1565213milkmen
mocked154716613mock_ed
mocker143315443mock_er
nocked134617383nock_ed
nomen75621623no__men
nonmen8412833no_nmen
oaken95814383_oak_en
ocker113915753_ock_er
oilmen848313_oilmen
omen66828183_o__men
packman1736693packman
pocked154818983pock_ed
pocket144622623pock_et
pockier153911603pockier
pocosen1146833pocosen
postmen113110423postmen
potmen102713093po_tmen
rocked135022323rock_ed
rocker124319573rock_er
rocket125425283rock_et
rockier134911883rockier
rockoon1345653rockoon
rodmen939713ro_dmen
rodsmen1035833rodsmen
sacked135525213sack_ed
sacker125124843sack_er
sagamen10127503sagamen
sandmen1039413sandmen
screen85216013s_creen
seamen84518563s_eamen
seedmen1037683seedmen
semen75724103s__emen
shaken134113613shak_en
shipmen14317283shipmen
shocked174611803shock_ed
shocker163411423shock_er
shopmen14277193shopmen
showmen15227163showmen
sickbed16396823sickbed
sicked134524403sick_ed
sickee124622223sick_ee
sickees134514213sickees
sickens134411483sick_ens
sicker124023903sick_er
sickie123715743sickie_
sickies133717503sickies
sickle124418323sickle_
sickled144713433sickled
sickles133417543sickles
sidemen1037943sidemen
silken104410853silk_en
skeen94817403s__keen
skymen1535313s_kymen
slacken13399933slack_en
slicken13309293slick_en
smocked16398223smock_ed
snowmen12246153snowmen
soaked114717593soak_ed
soaker105717533soak_er
socage91012123socage_
socager10107703socager
socages101012053socages
soccer1038543soc_cer
sock105233213sock___
socketed15177343socketed
sockets134012983sockets
sockeye1666413sockeye
sockeyes1765763sockeyes
socking143518603socking
sockless14267793sockless
socko115215113sock__o
socks114926083sock__s
socle7419573soc_le_
socles8418453soc_les
sodden84011513so_dden
soften9429493so_ften
soke85436263so_k_e_
sokeman1337263sokeman
sokes95031423so_k_es
solemn838643solem_n
soman75024903so__man
some66040383so__me_
sonarmen1045253sonarmen
soundmen1145233soundmen
spacemen1445413spacemen
specimen1444423specimen
spoken124610003spok_en
stamen84115943s_tamen
stickman1643943stickman
stocked144312873stock_ed
stocker133713083stock_er
stockier14217253stockier
sucked134120493suck_ed
sucker124120663suck_er
suckier133613973suckier
suckle124015963suckle_
suckled144212513suckled
suckler133413093suckler
suckles134516743suckles
sunken103511783sunk_en
surfmen1235993surfmen
swagmen1334973swagmen
swordmen1443003swordmen
token95419313to_k_en
tollmen935733tollmen
tongmen1037113tongmen
trackmen1635573trackmen
truckmen1643373truckmen
woken124614973wo_k_en
women104619253wo__men
woodmen1356053woodmen
woolmen1234973woolmen
workman1635613workman
yocked164114423yock_ed

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.1401276364.3
2DLD Change Limit1340271707.12618808.2
3Display Results1701700.0602833.3
 (SQL Overall)1786911707.32624391.3
 
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.