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

132 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
makeups153360(None) 
makeup1434861makeup_
takeups1333401takeups
makers123921732make_rs
makes115336852make__s
markups1534962markups
shakeups1742372shakeups
takeup1234582takeup_
akees96119243_ake_es
akelas10311193_akelas
akenes104817343_akenes
amateurs1043643amateurs
backups1736173backups
bakers125323453bake_rs
bakes117035373bake__s
barkeeps1634143barkeeps
cakes116037673cake__s
catsups1135343catsups
faceup1334893faceup_
fakeers14446673fakeers
fakers134219533fake_rs
fakes126032483fake__s
flareups1342473flareups
hakeems16394803hakeems
hakes126034303hake__s
hakus125114113hak_u_s
hangups1364813hangups
jakes165023643jake__s
jaups144810533ja__ups
keeps116020283__keeps
kelps115116423__kelps
kemps135012523__kemps
keps106027303__ke_ps
lakers105225153lake_rs
lakes95737653lake__s
larrups934733larrups
layups1133993la_yups
lineups934913lineups
mabes96331533mabe__s
macers105321273mace_rs
maces97139963mace__s
madcaps1435243madcaps
maes66948403ma_e__s
mages85036023mage__s
magilps1234083magilps
magnums1234683magnums
magueys1333943magueys
magus85318753ma_gu_s
mahouts1237143mahouts
makars124612633mak_ars
make105537893make___
makefast1743293makefast
maker114127813make__r
makings145413163makings
makos116518363mak__os
makuta1236393mak_uta
males75049793male__s
malleus92911313malleu_s
mameyes14376983mameyes
mameys13449523mame_ys
mamluks1543313mamluks
maneges103612143maneges
manes76648963mane__s
mantuas93410993mantuas
manus75924933ma_nu_s
maps86141053ma___ps
maquis17249483ma_quis
marauds1037553marauds
mares76457633mare__s
markers133516103marke_rs
markets133314033marke_ts
markup1436903markup_
marques182610863marques
marquis18247063marquis
masers84623453mase_rs
maskegs14375413maske_gs
maskers133913843maske_rs
masques18239363masques
masseurs1034923masseurs
matchups1743073matchups
maters85032393mate_rs
mates75251363mate__s
mateys115610943mate_ys
mauds85519273ma__uds
mauls76524953ma__uls
mauts75927193ma__uts
mavens114312973mave_ns
maxes145629533maxe__s
maypops16104453maypops
mazers173917093maze_rs
mazes165632173maze__s
mikes115129893mike__s
miskeeps1644163miskeeps
mixups1743263m_ixups
mockups1733343mockups
mokes114631033moke__s
mukluks1242413mukluks
muktuks1242253muktuks
museums1134563museums
oakums1264153oak_ums
pakehas1635313pakehas
pareus85420743pareu_s
pasteups1243493pasteups
pileups11365433pileups
rakees104516973rake_es
rakers104123573rake_rs
rakes94440353rake__s
rakus94413673rak_u_s
sakers104125433sake_rs
sakes95540753sake__s
saleps85014903sale_ps
sannups934463sannups
scaleups1243393scaleups
shakeup1632763shakeup_
shapeups1542723shapeups
skelps12407923_skelps
skeps115614253_ske_ps
smashups1543213smashups
takeouts1245363takeouts
takers103923743take_rs
takes94437793take__s
tuneups933333tuneups
upkeeps1532193upkeeps
vakeels14113733vakeels
wakens135012043wake_ns
wakers134822493wake_rs
wakes126633653wake__s
walkups1633013walkups
warmups1433813warmups
washups1534683washups
wikiups16132083wikiups
yaups105910743ya__ups

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.420425454.8
2DLD Change Limit1340271326.41020909.0
3Display Results1321320.0462869.6
 (SQL Overall)1786911326.87625987.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.