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

224 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
takeup123458(None) 
makeup1434861makeup
takeups1333401takeups
faceup1334892faceup
makeups1533602makeups
shakeup1632762shakeup
take84739262take__
taken94819142take_n
takeout1149872takeout
taker95229002take_r
takers103923742takers
takes94437792take_s
tuneup835202tuneup
akee85936813_ake_e
akees96119243_akees
akela9311343_akela
akene95818663_akene
backup1646613backup
bake105637513bake__
baked126130773bake_d
baker115629543bake_r
bakers125323453bakers
bakery155911003bakery
bakes117035373bake_s
barkeep1536363barkeep
cake105439963cake__
caked126128623cake_d
cakes116037673cake_s
cakey145517273cake_y
catsup1036433catsup
fake115534943fake__
faked135225483fake_d
fakeer13378743fakeer
faker124824593fake_r
fakers134219533fakers
fakery16509263fakery
fakes126032483fake_s
fakey155515423fake_y
flareup1243173flareup
hake115637843hake__
hakeem15407383hakeem
hakes126034303hake_s
haku116923893hak_u_
hakus125114113hak_us
hangup1277293hangup
jake155925773jake__
jakes165023643jake_s
jaup135316423ja__up
keep106329823__keep
kelp105322803__kelp
kemp126418763__kemp
kep96437203__ke_p
lake85741603lake__
laked105731123lake_d
laker95432873lake_r
lakers105225153lakers
lakes95737653lake_s
larrup835713larrup
layup1037723la_yup
lineup835983lineup
make105537893make__
maker114127813make_r
makers123921733makers
makes115336853make_s
markup1436903markup
naked105320853nake_d
oaken95814383oake_n
oakum1177313oak_um
pakeha1533933pakeha
pareu74928743pareu_
pareus85420743pareus
pasteup1134983pasteup
pileup10437923pileup
rake84841573rake__
raked105831423rake_d
rakee96031173rake_e
rakees104516973rakees
raker94529793rake_r
rakers104123573rakers
rakes94440353rake_s
raku85423773rak_u_
rakus94413673rak_us
sake85244963sake__
saker95132023sake_r
sakers104125433sakers
sakes95540753sake_s
salep77022953sale_p
sannup836563sannup
scaleup1134483scaleup
shakeups1742373shakeups
shapeup1443293shapeup
skelp114211423_skelp
skep105219353_ske_p
stackup1533743stackup
stake95927533stake__
staked114621943stake_d
stakeout1247143stakeout
stakes103927293stake_s
standup1034353standup
startup934963startup
taber73825823tabe_r
tabers84621573tabers
tabes76033923tabe_s
tabour84011323tabour
tabu66328493ta_bu_
tabued94310403tabued
tabun75914373ta_bun
tabus74820923ta_bus
tace65342513tace__
taces76237803tace_s
tacet75840023tace_t
tacked134723943tacke_d
tacker124224503tacke_r
tackers134319623tackers
tacket124627493tacke_t
tackets134914363tackets
tackey154613083tacke_y
tae38267053ta_e__
tael46030713ta_e_l
taels56822073ta_els
tajes124920693taje_s
taka87623593tak__a
takahe1335793takahe
takas95520683tak_as
takeoff1743883takeoff
takeouts1245363takeouts
takin94921303tak_in
taking114725953taking
takins105117403takins
talcum1036953talcum
tale46154163tale__
talent6323323talent
taler56034863tale_r
talers64628143talers
tales55451373tale_s
talked114015403talke_d
talker103916223talke_r
talkers113513213talkers
taluk94812873ta_luk
talus55423263ta_lus
tambur10358713tambur
tame66343663tame__
tamed85528513tame_d
tamein8313093tamein
tamely113711953tamely
tamer75230103tame_r
tamers84224033tamers
tames75242013tame_s
tamest85721293tamest
tamp86133003ta__mp
tanked113919293tanke_d
tanker104521123tanke_r
tankers113416913tankers
tankful1445163tankful
tap57663873ta___p
tape64538143tape__
taped85327423tape_d
taper74829773tape_r
tapers84025813tapers
tapes75838603tape_s
tapeta8310693tapeta
tapetum1145393tapetum
tare45957623tare__
tared69340053tare_d
tares57456563tare_s
tarp66936413ta__rp
tarsus6310513tarsus
tasked114714643taske_d
tate44748603tate__
tater54138613tate_r
taters64932203taters
tates55444983tate_s
tau36856903ta__u_
taupe7314163ta__upe
taus46342733ta__us
taut47048963ta__ut
tavern9428933tavern
tawed95926193tawe_d
tawer85223443tawe_r
tawers94118603tawers
taxed135620293taxe_d
taxeme1536253taxeme
taxer125019363taxe_r
taxers134015283taxers
taxes124730823taxe_s
taxus125512483ta_xus
teacup1036253teacup
temp85323333t__emp
thesp105410313t_hesp
threap11569663threap
threep115910113threep
tike85534483tike__
tikes95628903tike_s
tittup834203tittup
toke86738493toke__
toked105626493toke_d
token95419313toke_n
tokens104711563tokens
toker95924913toke_r
tokers104818893tokers
tokes95234973toke_s
tossup875293tossup
tsked105910033tske_d
tuneups933333tuneups
tup56037543t___up
turnup835093turnup
twerp10398413t_werp
tyke115720503tyke__
tykes125817063tyke_s
upkeep1434143upkeep
vakeel1335193vakeel
wake114935703wake__
waked135626753wake_d
wakeful1735613wakeful
waken124818473wake_n
wakens135012043wakens
waker125526593wake_r
wakers134822493wakers
wakes126633653wake_s
walkup1534193walkup
warmup1335343warmup
washup1435323washup
wikiup15183533wikiup
yaup96618483ya__up

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 Filter1786911127160.406440125.6
2DLD Change Limit1127162245.71619719.4
3Display Results2242240.0633555.6
 (SQL Overall)1786912246.18528891.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.