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

140 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
medakas143576(None) 
medaka1336341medaka_
medals94218052meda_ls
medias93620782med_ias
medinas103411462medinas
medusas1036212medusas
abakas123911743_abakas
beaks115326623be_ak_s
bedamns1235733bedamns
bedaubs1233693bedaubs
berakes134815773berakes
betakes134212523betakes
bidarkas1543363bidarkas
cedars93312833ceda_rs
cedulas1058503cedulas
dadas75819863__dadas
daks97130603__dak_s
dedans85915073deda_ns
deodaras1044693deodaras
edemas9310503_edemas
fedoras1137923fedoras
geladas936313geladas
indabas1045853indabas
judokas1992453judokas
kabakas12367403kabakas
kakas85117343__kakas
kanakas10327213kanakas
leaks95923913le_ak_s
madames12310063madames
madams11310943mada_ms
madras94316433mad_ras
madrasas11317763madrasas
makar115614973m__akar
makars124612633m__akars
makes115336853m__akes
makos116518363m__akos
mamas95930773m__amas
mananas93414733mananas
manas76240433m__anas
mandalas1139443mandalas
maracas11313773maracas
maras75443293m__aras
markas124717003m_arkas
markkas12356083markkas
masalas9312053masalas
masas75630413m__asas
mayas105924383m__ayas
meadows1337333meadows
meads85425323me_a_ds
meals75933373me_a_ls
means75831233me_a_ns
meatal84114733me_atal
meats75034053me_a_ts
meatus85112923me_atus
meccas1239493me_ccas
medal86221333med__al
medaled113411613medaled
medalist11414213medalist
meddles113213253meddles
medevac1553523medevac
medevacs1643373medevacs
media84721713med_ia_
mediad104313713med_iad
mediae94217413med_iae
medial93819863med_ial
medials103914733medials
median94117543med_ian
medians103214213medians
mediants11299493mediants
mediates112814063mediates
medical12312513medical
medicals1349363medicals
medicks16368413medicks
medicos12339833medicos
medics114115353med_ics
medigap1374623medigap
medigaps1463883medigaps
medina94114093medina_
mediums12308723mediums
medius93613283med_ius
medivac1554693medivac
medivacs1644003medivacs
medlar93010463med_lar
medlars10259443medlars
medleys13115333medleys
meds75735363med___s
medullas1144513medullas
medusa936293medusa_
medusae1044763medusae
medusal1035183medusal
medusan1044713medusan
medusans1144143medusans
meerkat1346943meerkat
meerkats1443453meerkats
megabar1244503megabar
megabars1344403megabars
megara9310093megara_
megass9219443mega_ss
melenas999203melenas
menaces112715523menaces
menads95514383mena_ds
menages103615393menages
mensas85115863me_nsas
merks114722403me_rk_s
mesas76823203me__sas
mesdames1346043mesdames
metages102714973metages
metals84520883meta_ls
metatag1045053metatag
metatags1144693metatags
metates92720013metates
metepas1136303metepas
mezuzas1743233mezuzas
midairs1037203midairs
modals93914453moda_ls
mousakas1442733mousakas
mudras94212263mud_ras
oedemas1056693oedemas
peaks114825623pe_ak_s
pedalos10329703pedalos
pedals94316033peda_ls
pedants10310113pedants
reatas64021013re_atas
redacts10510943redacts
redans75421023reda_ns
redates83423873redates
redias74523603red_ias
redowas1138393redowas
remakes134116173remakes
retakes113718863retakes
rewakes144614983rewakes
sedans74816093seda_ns
sedates83418043sedates
sifakas1443333sifakas
takas95520683__takas
teaks94222903te_ak_s
vedalias1245153vedalias
vodkas1443543vod_kas
wekas123911793we__kas
zenanas16286233zenanas

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 Limit1340271406.34321129.9
3Display Results1401400.0463043.5
 (SQL Overall)1786911406.79526297.4
 
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.