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

243 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
boatmen114691(None) 
batmen104414301b_atmen
boatman1147051boatman
boatsmen1245281boatsmen
badmen114613832b_admen
bagmen115412532b_agmen
barmen105418532b_armen
batman105214062b_atman
batsmen1146882b_atsmen
batten85217122b_atten
baymen134212002b_aymen
beadmen12299452beadmen
beaten84617062beat_en
boardmen1344072boardmen
boated94221972boat_ed
boatel84314092boat_el
boater84622092boat_er
boatsman1245702boatsman
bogymen1534762bogymen
bondmen1237892bondmen
bookmen15126262bookmen
bowmen1399852bo_wmen
footmen1246582footmen
meatmen1138242meatmen
oaten55222402_oat_en
postmen113110422postmen
potmen102713092po_tmen
admen84516183__admen
amen66733153__a_men
atman75520143__atman
axmen145112273__axmen
badman113813843b_adman
bagman114613813b_agman
baleen8613053b_aleen
bammed133913243b_ammed
barman103519703b_arman
barren85317613b_arren
basemen1139083basemen
bate66552423b_at_e_
bated85935533b_at_ed
bates75846343b_at_es
bathe105822883b_athe_
bathed125518743b_athed
bather115322513b_ather
bathes116524833b_athes
baton75822423b_at_on
batsman1157993b_atsman
batted95623653b_atted
battens95313263b_attens
batter84928873b_atter
bayman133712703b_ayman
beadman12249153beadman
beadsmen1385883beadsmen
beamed115720733bea_med
beater84729393beat_er
bedemen12910183bedemen
bellmen1138143bellmen
betaken13438283betaken
birdmen1235833birdmen
bitten84715123b_itten
bitumen1134503bitumen
blacken15439793blacken
blame95625493bla_me_
blamed116017953bla_med
blamer104417143bla_mer
blames105121863bla_mes
blastment1347163blastment
blate75933783blat_e_
blather125314203blather
blatted104812713blatted
blatter94415653blatter
bloated104513433bloat_ed
bloater94013423bloat_er
boarded113910503boarded
boarder103910323boarder
boardman1344393boardman
boasted104113743boasted
boaster94616433boaster
boat66360313boat___
boatels93510233boatels
boaters93419243boaters
boatful1236283boatful
boating103721303boating
boatneck1642703boatneck
boats75635153boat__s
bodement13410123bodement
bogeymen1643633bogeymen
bogyman1544933bogyman
boite74426323boit_e_
boites84322703boit_es
bolted94617803bolt_ed
bolter83920753bolt_er
bondman1238043bondman
bondsmen1345473bondsmen
boogymen1643103boogymen
bookman15136483bookman
boomed115318133bo_omed
boomer104618513bo_omer
booted94822733boot_ed
bootee84323023boot_ee
bootees94114473bootees
bootie85421163bootie_
booties94124613booties
bootleg10276633bootleg
borate85026153borat_e_
borated104116363borat_ed
borates94823013borat_es
boreen8314313bo_reen
bortzes1838223bortzes
bosomed1238003bosomed
boston8513043bost_on
botel75121863bo_t_el
bother115218063bo_ther
bottle84916073bottle_
bottled104611233bottled
bottler94211883bottler
bottles94216273bottles
bottomed1344673bottomed
bottomer1245103bottomer
bounden10389453bounden
bouton8311533bout_on
bowman13129853bo_wman
bracken15409813bracken
brakemen1644843brakemen
brazen174812453bra_zen
broaden10289143broa_den
burthen1236363burthen
bushmen1436303bushmen
busmen1039893b_usmen
cabmen123610653_cabmen
carmen104019343_carmen
chapmen1637283chapmen
coachmen1745013coachmen
coarsen93210323coarsen
coated94927043coat_ed
coatee84327223coat_ee
coatees93816553coatees
coater84329573coat_er
coattend1134653coattend
contemn1137803contemn
cowmen13810923co_wmen
daimen92210573_daimen
deadmen11248573deadmen
doated84118183doat_ed
dolmen93911373do_lmen
doormen1036753doormen
draymen1335233draymen
dustmen1035773dustmen
eaten55323053_eat_en
examen1538283exa_men
fatten94314903_fatten
flagmen13226913flagmen
flamen115215993fla_men
flatten10429653flatten
foamed126014403foa_med
foamer114714313foa_mer
foemen11310523fo_emen
footman1236403footman
foramen12310533foramen
foremen12412923foremen
frontmen1344423frontmen
gagmen103910413_gagmen
gasmen93111563_gasmen
gatemen1047603_gatemen
goatee73219533goat_ee
goateed9307063goateed
goatees82710443goatees
goodmen1135623goodmen
gotten73410113go_tten
headmen13259513headmen
heathen133410893heathen
hitmen11239193_hitmen
hoarsen10367993hoarsen
hoatzin1943943hoatzin
lateen64014863_lateen
laten54328343_lat_en
latten65018203_latten
lawmen11308593_lawmen
laymen113010843_laymen
leadmen10277903leadmen
liftmen1234233liftmen
loamed94414613loa_med
loathe94211383loathe_
loathed11419443loathed
loather103711003loather
loathes103513243loathes
madmen113511743_madmen
meatman1137903meatman
moated94819003moat_ed
molten83311813molt_en
neaten64214543neat_en
nomen75621623no__men
nonmen8412833no_nmen
oaken95814383_oa_ken
oarsmen938093_oarsmen
oater55433733_oat_er
oatmeal944973_oatmeal
often84611413_oft_en
oilmen848313_oilmen
omen66828183_o__men
outman83115033_outman
paten74827343_pat_en
patten84418193_patten
pitmen102510793_pitmen
platen84518203plat_en
pointmen1245423pointmen
posteen93512623posteen
postman112410043postman
poteen83514263po_teen
potman102813573po_tman
potteen9319673potteen
putamen1135923putamen
ragmen93712183_ragmen
ramen75625193_ra_men
ratten64217383_ratten
roamed95215093roa_med
roamer84715163roa_mer
rodmen939713ro_dmen
rodsmen1035833rodsmen
rontgen835173rontgen
rotten64115433ro_tten
routemen10105813routemen
sateen63815013_sateen
seamen84518563sea_men
sockmen1535453sockmen
socmen1039193so_cmen
soften9429493soft_en
sokemen1337053sokemen
sonarmen1045253sonarmen
stamen84115943sta_men
swagmen1334973swagmen
taxmen15367443_taxmen
titmen8239883_titmen
tollmen935733tollmen
tongmen1037123tongmen
torten65314353tort_en
vanmen1138403_vanmen
women104619253wo__men
woodmen1356053woodmen
woolmen1234973woolmen
workmen1635933workmen
yamen104115183_ya_men
youthen1336153youthen

Search took 9 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 Limit1340272437.48317910.9
3Display Results2432430.0932612.9
 (SQL Overall)1786912437.98222386.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.