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 “bogyman” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
bogyman154493(None) 
bogeyman1643221bogeyman
bogymen1534761bogymen
boogyman1643091boogyman
bagman114613812bag_man
bayman133712702b_ayman
boatman1147052boatman
bogan87519002bog__an
bogbean1244642bogbean
bogeymen1643632bogeymen
bondman1238042bondman
boogeyman1751592boogeyman
boogymen1643102boogymen
bookman15136482bookman
bowman13129852bo_wman
badman113813843b_adman
bagmen115412533bag_men
banyan1139483bany_an
bargeman1345143bargeman
barman103519703b_arman
baseman1138553baseman
batman105214063b_atman
batsman1157993batsman
baymen134212003b_aymen
beadman12249153beadman
bedeman12168843bedeman
began86319573beg__an
begroan1036103begroan
bellman1137183bellman
birdman1236673birdman
boardman1344393boardman
boatmen1146913boatmen
boatsman1245703boatsman
bodhran1343943bodhran
bogans95714813bog__ans
bogbeans1343453bogbeans
bogy106426193bogy___
bogyism1545213bogyism
bohemian1544763bohemian
bondmen1237893bondmen
bondsman1345693bondsman
boogerman1442883boogerman
boogeymen1751983boogeymen
boogieman1451553boogieman
bookmen15126263bookmen
bowmen1399853bo_wmen
boyar106013763bo_y_ar
boyla102912363bo_yla_
boylas113011723bo_ylas
brogan9311043brog__an
bushman1455693bushman
busman10310253b_usman
cayman133613213_cayman
cowman13910373co_wman
dogma96112463dog_ma_
dogmas105011243dog_mas
dolman95312403do_lman
doorman1037063doorman
drayman1335433drayman
flyman14326423_flyman
foeman11311233fo_eman
footman1236403footman
foreman12312363foreman
frogman1335873frog_man
gagman103811243gag_man
goodman1135933goodman
hogan97817703hog__an
hogmane1336343hog_mane
juryman1943583juryman
layman113511303_layman
legman949653leg_man
logan68123283log__an
moneyman1545223moneyman
nonman8412363no_nman
oilman839483_oilman
outman83115033_outman
postman112410043postman
potman102813573po_tman
ragman94013713rag_man
rodman949713ro_dman
rodsman1036653rodsman
roman75424823ro__man
sagaman10117563sagaman
skyman1535313_skyman
sockman1535663sockman
socman1039813so_cman
sokeman1337263sokeman
soman75024903so__man
tollman935863tollman
toman75724053to__man
tongman1037573tongman
woman105818003wo__man
woodman1336313woodman
woolman1235433woolman
workman1635613workman
yeggman1442923yeggman

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.403443402.0
2DLD Change Limit134027966.45620760.1
3Display Results96960.0303200.0
 (SQL Overall)178691966.88925938.6
 
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.