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

173 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
medaka133634(None) 
medakas1435761medakas
medal86221322meda_l
medals94218042medals
media84721712med_ia
medina94114092medina
medusa936292medusa
megara9310092megara
abaka114313823_abaka
beak106534383be_ak_
beaks115326623be_aks
beaky146118023be_aky
bedamn1137813bedamn
bedaub1146033bedaub
bemata10411693bemata
berake124216083berake
betake124512703betake
bidarka1443843bidarka
cedar84014323ceda_r
cedarn9408443cedarn
cedars93312833cedars
cedary12419603cedary
cedula977643cedula
dada66422443__dada
dak86340693__dak_
daks97130603__daks
data56026653__data
dedal75719023deda_l
dedans85915073dedans
deodara945243deodara
edema8610553_edema
emdash12244113emdash
fedora1038593fedora
gelada837623gelada
indaba935613indaba
judoka18102583judoka
kabaka11348503kabaka
kaka76518683__kaka
kanaka9357523kanaka
leak86233713le_ak_
leaks95923913le_aks
leaky125217723le_aky
madam10316223mada_m
madame1139853madame
madams11310943madams
madrasa10387883madrasa
makar115614973m__akar
make105537883m__ake
mako105622353m__ako
mama86231583m__ama
mana65341943m__ana
manana84816073manana
mandala10310203mandala
mara67444563m__ara
maraca10314153maraca
marka114620793m_arka
markka11416593markka
masa65034713m__asa
masala8311813masala
maya95824583m__aya
mead75531603me_a_d
meadow1237403meadow
meads85425323me_ads
meal65643173me_a_l
meals75933373me_als
mealy104422183me_aly
mean65538083me_a_n
means75831223me_ans
meant76537203me_ant
meany104620473me_any
meat66359603me_a_t
meatal84114733me_atal
meats75034053me_ats
meaty107021313me_aty
mecca1139933me_cca
med66146743med___
medaled113411603medaled
meddle103312763meddle
medevac1553523medevac
medfly1535223medfly
mediacy1536143mediacy
mediad104313713mediad
mediae94217413mediae
medial93819863medial
medials103914733medials
median94117543median
medians103214213medians
mediant103516703mediant
medias93620783medias
mediate103415213mediate
medic104619653med_ic
medical12312513medical
medick154010133medick
medicks16368413medicks
medico113711163medico
medics114115353medics
medigap1374623medigap
medii84513493med_ii
medinas103411463medinas
medium113711623medium
medius93613283medius
medivac1554693medivac
medlar93010463medlar
medlars10259443medlars
medley1298333medley
meds75735363med__s
medulla1044713medulla
medusae1044763medusae
medusal1035183medusal
medusan1044713medusan
medusas1036213medusas
meek105624833me_ek_
meerkat1346943meerkat
mega77620873me__ga
megabar1244503megabar
megass9219443megass
melena81110473melena
menace103216943menace
menad85918983mena_d
menads95514383menads
menage93216543menage
mensa75318663me_nsa
menta74424423me_nta
merk106027943me_rk_
merks114722403me_rks
mesa67025483me__sa
mesas76823203mesa_s
meta65932413me__ta
metage93114453metage
metal75427383meta_l
metals84520883metals
metatag1045053metatag
metate82720533metate
metazoa1845543metazoa
metepa1066013metepa
mezuza1643533mezuza
midair937983midair
modal85919233moda_l
modals93914443modals
modica11310063modica
mousaka1343173mousaka
mudra83912433mud_ra
oedema936573oedema
peak106535203pe_ak_
peaks114825623pe_aks
peaky145718153pe_aky
pedal86022503peda_l
pedalo93811143pedalo
pedals94316033pedals
pedant9319493pedant
pedate93117763pedate
reata54225393re_ata
redact9419043redact
redan66125013reda_n
redans75421023redans
redate74124683redate
redia65524483red_ia
redowa1038453redowa
remake124016113remake
retake104718533retake
rewake135218463rewake
sedan65620423seda_n
sedans74816093sedans
sedate73019803sedate
sifaka1353553sifaka
taka87623593__taka
teak85930843te_ak_
teaks94222903te_aks
vedalia1145673vedalia
vodka1354343vod_ka
weak117126303we_ak_
weka117013873we__ka
zenana15297983zenana

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161738.18613769.4
3Display Results1731730.0463760.9
 (SQL Overall)1786911738.37221343.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.