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

179 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
workmen163593(None) 
workman1635611workman
bookmen15126262bookmen
foramen12310532foramen
foremen12412922foremen
kirkmen1232922kirkmen
sockmen1535452sockmen
swordmen1443002swordmen
wiremen1236902wiremen
woken124614972wo_k_en
women104619252wo__men
woodmen1356052woodmen
woolmen1234972woolmen
worked145314702work_ed
worker134715112work_er
workwomen2143792workwomen
wormed124314302wor_med
wormer114514912wor_mer
worsen95513872wor_sen
airmen82612353air_men
awoken13457163awo_k_en
barmen105418533bar_men
birdmen1235833birdmen
boardmen1344073boardmen
boatmen1146913boatmen
bogymen1534763bogymen
bondmen1237893bondmen
bookman15136483bookman
boreen8314313bor_een
borked135117293bork_ed
bowmen1399853bo_wmen
broken124011523brok_en
carmen104019343car_men
cerumen1147763cerumen
choremen1597603choremen
corked135020783cork_ed
corker124720853cork_er
corkier133114303corkier
cormel103815603cor_mel
corpsmen1445623corpsmen
cowmen13810923co_wmen
darken114013443dark_en
deskmen1435023deskmen
dolmen93911373do_lmen
doormen1036753doormen
dorkier122810023dorkier
dormer94415903dor_mer
dormin9312313dor_min
duramen1096903duramen
firemen1238773firemen
foemen11310523fo_emen
footmen1246583footmen
foramens1337823foramens
foreman12312363foreman
forked145217143fork_ed
forker134717903fork_er
forkier144311593forkier
forme105225993for_me_
formed125021173for_med
formee113919943for_mee
former114221403for_mer
formes114623713for_mes
frogmen1335893frogmen
germen9612313ger_men
goodmen1135623goodmen
gorhen1038893gor_hen
gormed105013833gor_med
hackmen1836713hackmen
harken135116343hark_en
herdmen13238453herdmen
horsemen1347483horsemen
ironmen936453ironmen
junkmen2033633junkmen
jurymen1943133jurymen
kirkman1243773kirkman
linkmen1335363linkmen
lorimer937753lorimer
marksmen1644533marksmen
mermen10813813mer_men
milkmen1565213milkmen
moreen8313343mor_een
morgen9312203mor_gen
nomen75621623no__men
nonmen8412833no_nmen
normed95014543nor_med
oaken95814383_oak_en
oarsmen938093oarsmen
oilmen848313_oilmen
omen66828183_o__men
ormer75218373_or_mer
packmen1746313packmen
porked134717623pork_ed
porker124917543pork_er
porkier133712343porkier
porkies133416493porkies
postmen113110423postmen
potmen102713093po_tmen
premen105017803_premen
propmen1338763propmen
ramen75625193__ramen
rodmen939713ro_dmen
rodsmen1035833rodsmen
rumen74419503__rumen
sockman1535663sockman
socmen1039193so_cmen
sokemen1337053sokemen
stockmen1643923stockmen
surfmen1235993surfmen
swordman1443403swordman
swordsmen1542173swordsmen
token95419313to_k_en
tollmen935733tollmen
tongmen1037123tongmen
torment9316173tor_ment
torten65314353tor_ten
turfmen1244163turfmen
waken124818473w_ak_en
warden104515513war_den
warked144421213wark_ed
warmed124516893war_med
warmer113816733war_mer
warren95012853war_ren
weaken13349603weak_en
wingmen1336113wingmen
wireman1237843wireman
woke115527963wo_k_e_
woman105818003wo__man
womyn13426363wo__myn
wonkier1437423wonkier
wooden103610303wo_oden
woodhen1454723woodhen
woodman1336313woodman
woodsmen1444633woodsmen
woolen93111373wo_olen
woollen1034723woollen
woolman1235433woolman
worded114316623wor_ded
wordier112511213wordier
wore77144673wor__e_
work115528843work___
workbag1742923workbag
workbench2361453workbench
workbox2343313workbox
workday1843303workday
workers144612693workers
working153813253working
workingmen2051103workingmen
workless15276803workless
workmanly2151993workmanly
workmate1744673workmate
workmates1845003workmates
workout1448393workout
works125621903work__s
workup1534323work_up
workups1633613workups
workweek1742133workweek
workwoman2143103workwoman
worm96129493wor_m__
wormers124012573wor_mers
wormier12278763wormier
wormil1138043wor_mil
worming132811243wor_ming
worms105320763wor_m_s
wormy137514253wor_m_y
worn75631753wor___n
worried11308693worried
worrier102311683worrier
worries104117133worries
worriment1445583worriment
worse86525263wor_se_
worsens104610263wor_sens
worser95117523wor_ser
worses95522953wor_ses
worset96726583wor_set
worsted1138013worsted
worthed1437873worthed
woven115215173wo__ven
wren78221683w_r__en
yardmen1335423yardmen

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 Limit1340271797.04619021.7
3Display Results1791790.0632841.3
 (SQL Overall)1786911797.51523777.9
 
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.