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

206 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
footmen124658(None) 
footman1236401footman
boatmen1146912boatmen
bookmen15126262bookmen
doormen1036752doormen
foemen11310522f_oemen
footed104418622foot_ed
footer94320772foot_er
footie94718142footie_
footier104115112footier
footies103721542footies
footle93914382footle_
footled113610762footled
footler104011872footler
footles103715712footles
foramen12310532foramen
foremen12412922foremen
frogmen1335892frogmen
frontmen1344422frontmen
goodmen1135622goodmen
postmen113110422postmen
potmen102713092_potmen
woodmen1356052woodmen
woolmen1234972woolmen
automen939653automen
batmen104414303_batmen
boatman1147053boatman
boatsmen1245283boatsmen
bogymen1534763bogymen
bondmen1237893bondmen
boogymen1643103boogymen
bookman15136483bookman
boomed115318133boo_med
boomer104618513boo_mer
booted94822733boot_ed
bootee84323023boot_ee
bootees94114473bootees
bootie85421163bootie_
booties94124613booties
bootleg10276633bootleg
bowmen1399853_bowmen
colormen1247243colormen
contemn1137803contemn
cooter85128613coot_er
cootie84223093cootie_
cooties93725733cooties
cowmen13810923_cowmen
dolmen93911373_dolmen
doomed104113293doo_med
doorman1037063doorman
dustmen1035773dustmen
fasten95114893fast_en
fatten94314903f_atten
fifteen1343923fifteen
firemen1238773firemen
fitment12710303f_itment
flagmen13226913flagmen
flamen115215993f_lamen
flatten10429653flatten
flehmen1534913flehmen
flymen14387773f_lymen
foamed126014403f_oamed
foamer114714313f_oamer
foeman11311233f_oeman
foilsmen1354103foilsmen
foment113718303f_o_ment
foodie104413843foodie_
foodies113416753foodies
fooled104317823foo_led
foot76248013foot___
footage1148843footage
footages1239053footages
footbag1344553footbag
footboy1544913footboy
footers104618333footers
footgear12113063footgear
footiest113514913footiest
footing115017593footing
footlers113910793footlers
footless113710803footless
footling12239923footling
footmark1743833footmark
footpad1343903footpad
footrest11308853footrest
foots85528283foot__s
footsie1047653footsie
footsies1139643footsies
footstep1363823footstep
footsy12587933foot_sy
footway1635253footway
footwear14103373footwear
footworn1445163footworn
footy115820533foot__y
foozle18369203foozle_
foozled20346893foozled
foozler19397593foozler
foozles19329543foozles
foramens1337823foramens
foreman12312363foreman
forgotten1342103forgotten
forme105225993f_orme_
formed125021173f_ormed
formee113919943f_ormee
former114221403f_ormer
formes114623713f_ormes
forte86131463fort_e_
fortes95327183fort_es
forties104323863forties
fortune1068303fortune
foster94322223fost_er
fourteen1144503fourteen
freemen1238463freemen
frogman1335873frogman
frontman1344303frontman
frothed14288783frothed
frother133110153frother
frozen18408443fro_zen
goodman1135933goodman
gotten73410113_gotten
hitmen11239193_hitmen
hooted104422663hoot_ed
hooter94123933hoot_er
hootier104915353hootier
ironmen936453ironmen
liftmen1234233liftmen
loomed94616763loo_med
loosen66615963loo_sen
looted74421113loot_ed
looter64222323loot_er
meatmen1138243meatmen
molten83311813molt_en
moorhen1236023moorhen
mooted94120373moot_ed
mooter83921093moot_er
motormen1245703motormen
nomen75621623_no_men
nonmen8412833_nonmen
oaten55222403_oat_en
often84611413_oft_en
oilmen848313_oilmen
omen66828183__o_men
outman83115033_outman
pitmen102510793_pitmen
pivotmen1542653pivotmen
plowmen1434883plowmen
pointmen1245423pointmen
posteen93512623posteen
postman112410043postman
poteen83514263_poteen
potman102813573_potman
potteen9319673potteen
propmen1338763propmen
rodmen939713_rodmen
rodsmen1035833rodsmen
rontgen835173rontgen
roomed95218543roo_med
roomer84718633roo_mer
rooted75424003root_ed
rooter64926033root_er
rootier74915393rootier
rootle63214453rootle_
rootled83410533rootled
rootles73215633rootles
rootlet73015733rootlet
rotten64115433_rotten
routemen10105813routemen
shopmen14277203shopmen
shotten10288463shotten
showmen15227173showmen
smoothen13204963smoothen
snowmen12246153snowmen
sockmen1535453sockmen
socmen1039193_socmen
soften9429493soft_en
sokemen1337053sokemen
sooted73922593soot_ed
soothe94214853soothe_
soothed113712743soothed
soother104215043soother
soothes103917113soothes
sootier73916613sootier
titmen8239883_titmen
tollmen935733tollmen
tongmen1037123tongmen
tooted74620123toot_ed
tooter64420803toot_er
toothed113310243toothed
tootle62613813tootle_
tootled83511043tootled
tootler73511123tootler
tootles72915603tootles
tootses72910773tootses
torten65314353tort_en
women104619253_wo_men
wooden103610303woo_den
woodhen1454723woodhen
woodman1336313woodman
woodsmen1444633woodsmen
woolen93111373woo_len
woollen1034723woollen
woolman1235433woolman
workmen1635933workmen
yeomen1138183yeo_men
youthen1336153youthen
zoomed183610363zoo_med
zootier163611173zootier

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.420425454.8
2DLD Change Limit1340272066.98619185.1
3Display Results2062060.0633269.8
 (SQL Overall)1786912067.46923924.4
 
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.