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

126 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
hogmane133634(None) 
hogmanes1446781hogmanes
dogbane1135652dogbane
dogvane1243852dogvane
hogan97817702hog_an_
hogans105914312hog_ans
hogmanay1762842hogmanay
homage121210602ho_mage
hormone12410502hormone
humane112812172h_umane
bagman114613813bagman_
bogan87519003bog_an_
bogans95714813bog_ans
bogyman1544933bogyman_
borane84620213bo_rane
bowman13129853bowman_
bugbane1255863bugbane
cognate10312203cognate
comade114415323co_made
comae97128423co_ma_e
comake144413423co_make
comate104124843co_mate
command14399213command
commune13329363commune
cowbane1437673cowbane
cowman13910373cowman_
dogbanes1245433dogbanes
dogface1454053dogface
doggone1035683doggone
dogma96112463dogma__
dogmas105011243dogma_s
dogmata1145143dogmata
dogvanes1344303dogvanes
dolman95312403dolman_
dolmans10479683dolmans
domaine10610503do_maine
domine92918253do_mine
dormant102814373dormant
foeman11311233foeman_
foggage1334113foggage
formant123416003formant
formate123115093formate
frogman1335873frogman_
gagman103811243gagman_
gane55145303__g_ane
germane1049663germane
gormand1157453gormand
hamate113319833h_amate
hangman1337813hangman_
harmine122816193harmine
hegumene1443983hegumene
henbane1237353henbane
heptane1238363heptane
hermae115314473herma_e
hetman112510603hetman_
hetmans12187593hetmans
hexane16379533h_exane
hitman112710223hitman_
hoecake1645203hoecake
hogback1945453hogback
hogging133112803hogging
hoglike15157733hoglike
hogmanays1881703hogmanays
hogmenay1753883hogmenay
hognose11117243hognose
hogtie102711773hog_tie
hogwash1742713hogwash
holland11349473holland
homaged1497413ho_maged
homager13107853ho_mager
homages131011583ho_mages
hombre13309303ho_mbre
home98042443ho_m__e
homemade1645143homemade
homie104622533ho_m_ie
homines123518643ho_mines
homing123718383ho_ming
hominy144511483ho_miny
honan85319773ho_nan_
honans94814503ho_nans
hone77549323ho___ne
hormones13311163hormones
hostage113111233hostage
hotcake1644543hotcake
hotline10712353hotline
human102716033h_uman_
humaner12257663h_umaner
humans112312433h_umans
humate113214443h_umate
hygiene1443473hygiene
immane1038883_immane
legman949653legman_
logan68123283log_an_
logans76319063log_ans
mane65052033___mane
montane91313623montane
nonman8412363nonman_
normande1145943normande
octane81411633_octane
ohmage1295063_ohmage
pomace123111913po_mace
pomade113611333po_made
potman102813573potman_
ragman94013713ragman_
rodman949713rodman_
romaine9512123ro_maine
roman75424823ro_man_
romance11311083ro_mance
romano84912943ro_mano
romans84620243ro_mans
shopman14247263shopman_
showman15257293showman_
sigmate10710143sigmate
socman1039813socman_
soman75024903so_man_
somans84619303so_mans
soutane7312063soutane
togae67020113tog_a_e
togate74515683tog_ate
tolane64316583to_lane
toman75724053to_man_
tomans85419133to_mans
tongman1037573tongman_
woman105818003wo_man_
womaned1337213wo_maned
womans114613653wo_mans

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.406440125.6
2DLD Change Limit1340271265.76623244.4
3Display Results1261260.0462739.1
 (SQL Overall)1786911266.21828737.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.