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

142 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
takeups133340(None) 
makeups1533601makeups
takeup1234581takeup_
makeup1434862makeup_
shakeups1742372shakeups
takeouts1245362takeouts
takers103923742take_rs
takes94437792take__s
tuneups933332tuneups
akees96119243_ake_es
akelas10311193_akelas
akenes104817343_akenes
backups1736173backups
bakers125323453bake_rs
bakes117035373bake__s
barkeeps1634143barkeeps
cakes116037673cake__s
catsups1135343catsups
faceup1334893faceup_
fakeers14446673fakeers
fakers134219533fake_rs
fakes126032483fake__s
flareups1342473flareups
hakeems16394803hakeems
hakes126034303hake__s
hakus125114113hak_u_s
hangups1364823hangups
jakes165023643jake__s
jaups144810533ja__ups
keeps116020283__keeps
kelps115116423__kelps
kemps135012523__kemps
keps106027313__ke_ps
lakers105225153lake_rs
lakes95737653lake__s
larrups934733larrups
layups1133993la_yups
lineups934913lineups
makers123921733make_rs
makes115336853make__s
markups1534963markups
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
stackups1643313stackups
stakeouts1344403stakeouts
stakes103927293stake__s
standups1143963standups
startups1033893startups
tabers84621573tabe_rs
tabes76033923tabe__s
tabours94110093tabours
tabuns8489223ta_buns
tabus74820923ta_bu_s
taces76237803tace__s
tackers134319623tacke_rs
tackets134914363tacke_ts
taels56822073ta_e_ls
tajes124920693taje__s
takahes1436173takahes
takas95520683tak__as
take84739263take___
taken94819143take__n
takeoff1743883takeoff
takeoffs1842323takeoffs
takeout1149873takeout
taker95229003take__r
takings124512573takings
takins105117403tak_ins
talcums1135513talcums
talents7312013talents
talers64628153tale_rs
tales55451373tale__s
talkers113513213talke_rs
taluks10418283ta_luks
talus55423263ta_lu_s
tamburs11288613tamburs
tameins9311423tameins
tamers84224033tame_rs
tames75242013tame__s
tamps95524093ta__mps
tankers113416913tanke_rs
tankfuls1543803tankfuls
tapers84025813tape_rs
tapes75838603tape__s
taps66050683ta___ps
tares57456563tare__s
tarps76527123ta__rps
tarsus6310513tarsu_s
taters64932203tate_rs
tates55444983tate__s
taupe7314173ta__upe
taupes8212673ta__upes
taus46342733ta__u_s
tauts56125513ta__uts
taverns10317803taverns
tawers94118603tawe_rs
taxemes1635853taxemes
taxers134015283taxe_rs
taxes124730823taxe__s
taxus125512483ta_xu_s
teacups1133963teacups
temps95417133t__emps
thesps11448263t_hesps
threaps12488643threaps
threeps12687043threeps
tikes95628903tike__s
tittups933353tittups
tokens104711563toke_ns
tokers104818893toke_rs
tokes95234973toke__s
tossups964023tossups
tuneup835203tuneup_
tups65628763t___ups
turnups933893turnups
twerps11345153t_werps
tykes125817063tyke__s
upkeeps1532193upkeeps
vakeels14113733vakeels
wakens135012043wake_ns
wakers134822503wake_rs
wakes126633653wake__s
walkups1633013walkups
warmups1433813warmups
washups1534683washups
wikiups16132083wikiups
yaups105910743ya__ups

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.423422437.4
2DLD Change Limit1340271427.64017542.8
3Display Results1421420.0463087.0
 (SQL Overall)1786911428.10922036.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.