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

110 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
bogymen153476(None) 
bogeymen1643631bogeymen
bogyman1544931bogyman
boogymen1643101boogymen
bagmen115412532bag_men
baymen134212002b_aymen
boatmen1146912boatmen
bogeyman1643222bogeyman
bondmen1237892bondmen
boogeymen1751982boogeymen
boogyman1643092boogyman
bookmen15126262bookmen
bowmen1399852bo_wmen
badmen114613833b_admen
bagman114613813bag_man
bargemen1346403bargemen
barmen105418533b_armen
basemen1139083basemen
batmen104414303b_atmen
batsmen1146883batsmen
bayman133712703b_ayman
beadmen12299453beadmen
bedemen12910183bedemen
bellmen1138143bellmen
biogen9310253biog__en
birdmen1235833birdmen
bitumen1134503bitumen
boardmen1344073boardmen
boatman1147053boatman
boatsmen1245283boatsmen
bodement13410123bodement
bogan87519003bog__an
bogbean1244643bogbean
bogey115220233bog__ey
bogeyed1435673bogeyed
bogged116019283bog_ged
boggier113711583boggier
boggle104511943boggle_
boggled12409003boggled
boggler113910083boggler
boggles113411823boggles
bogie89524103bog_ie_
bogies94724313bog_ies
bogle85821683bog_le_
bogles95020833bog_les
bogy106426193bogy___
bogyism1545213bogyism
bondman1238043bondman
bondsmen1345473bondsmen
boogermen1443083boogermen
boogeyman1751593boogeyman
boogiemen1452043boogiemen
bookman15136483bookman
boomed115318133bo_omed
boomer104618513bo_omer
boreen8314313bo_reen
bosomed1238003bosomed
boughten1444193boughten
bounden10389453bounden
bowman13129853bo_wman
bowyer14368923bowy_er
bushmen1436303bushmen
busmen1039893b_usmen
cognomen1346083cognomen
cowmen13810923co_wmen
dolmen93911373do_lmen
doormen1036753doormen
doyen95014413do_y_en
draymen1335233draymen
flymen14387773_flymen
foemen11310523fo_emen
footmen1246583footmen
foramen12310533foramen
foremen12412923foremen
frogmen1335893frog_men
gagmen103910413gag_men
goodmen1135623goodmen
hegumen1355463hegumen
hoyden13328933ho_yden
hymen13311043__hymen
jurymen1943133jurymen
laymen113010843_laymen
legmen939343leg_men
moneymen1545653moneymen
nomen75621623no__men
nonmen8412833no_nmen
oilmen848313_oilmen
omen66828183_o__men
oxygen1743313_oxygen
polymer1438063polymer
postmen113110423postmen
potmen102713093po_tmen
ragmen93712183rag_men
regimen104411573regimen
rodmen939713ro_dmen
rodsmen1035833rodsmen
sagamen10127503sagamen
skymen1535313_skymen
sockmen1535453sockmen
socmen1039193so_cmen
sokemen1337053sokemen
tegmen988403teg_men
tegumen10105423tegumen
tollmen935733tollmen
tongmen1037123tongmen
women104619253wo__men
woodmen1356053woodmen
woolmen1234973woolmen
workmen1635933workmen
yeggmen1442673yeggmen

Search took 7 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.423422437.4
2DLD Change Limit1340271106.40320931.9
3Display Results1101100.0333333.3
 (SQL Overall)1786911106.85926052.0
 
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.