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

235 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
markka1141659(None) 
marka114620791mar_ka
markkaa12373921markkaa
markkas12356081markkas
mara67444572mar__a
maraca10314152maraca
maria75032882mar_ia
marina84623412marina
mark105138062mar_k_
markas124717002markas
marked133921622marked
marker124420392marker
market123226042market
marks115933482mar_ks
markup1436902markup
parka115120882par_ka
abaka114313823_abaka
amarna839793amar_na
amrita8411133amrita
arak86929573_arak_
araks94820883_araks
area45843393_ar_ea
areca75618633_areca
arena55323813_arena
arepa75615563_arepa
aria46245423_ar_ia
ark77044963_ar_k_
arks85936873_ar_ks
aroma71220143_aroma
babka137812913ba_bka
barca91319433bar_ca
bark106242153bar_k_
barked135027313barked
barker124822863barker
barks115735813bar_ks
barky145721613bar_ky
baryta114310293baryta
burka114617693bur_ka
cardia9916383cardia
carina84325333carina
cark105539273car_k_
carked134024823carked
carks115534213car_ks
charka154011703char_ka
charkha19405153charkha
chukka1433013chukka
clarkia1334873clarkia
dark95133213dar_k_
darked123919633darked
darken114013443darken
darker114718693darker
darkey145212423darkey
darkie113714013darkie
darkle113813943darkle
darkly145411073darkly
darks106727873dar_ks
darky136018833dar_ky
eureka1034483eureka
farina94618233farina
garda7316763gar_da
haika125313793ha_ika
hark115237393har_k_
harked145422553harked
harken135116343harken
harks126333433har_ks
jarina134014063jarina
kabaka11348503kabaka
kaka76518683ka__ka
kanaka9357523kanaka
karma113415003kar_ma
lark85733863lar_k_
larked114519473larked
larker104519243larker
larks95227813lar_ks
larky125218873lar_ky
larva8312483lar_va
mack125733653ma_ck_
mackle143716433mackle
macks135127603ma_cks
macula103013673macula
madrasa10387883madrasa
madrona10288703madrona
maffia14327203maffia
mafia104418033ma_fia
magma104513573ma_gma
makar115614973ma_kar
make105537893ma__ke
maker114127813ma_ker
makes115336853ma_kes
mako105622363ma__ko
makos116518363ma_kos
makuta1236393makuta
malkin122913153malkin
maltha1137503maltha
mama86231593ma__ma
mamba116317523ma_mba
mamma86317913ma_mma
mana65341963ma__na
manana84816073manana
manga85026203ma_nga
mania75634153ma_nia
manila84518303manila
manna75522543ma_nna
manta75629913ma_nta
mantra84116093mantra
mantua84412023mantua
mar57965953mar___
maracas11313773maracas
maranta9311693maranta
maras75443293mar_as
marasca1136823marasca
maraud938943maraud
marble104219103marble
marbly134111933marbly
marc87034633mar__c
marcel103714853marcel
march125622893mar_ch
marcs95726623mar_cs
mare64759333mar__e
maremma1044463maremma
mares76457633mar_es
margay12310593margay
marge85328333mar_ge
marges94525713marges
margin94016853margin
marimba1354983marimba
marinas93519393marinas
marine84230403marine
marish114319053marish
marital92314183marital
markers133516103markers
markets133314033markets
markhor1635463markhor
marking144020133marking
marksman1645263marksman
markups1534963markups
marl66341623mar__l
marled95523163marled
marlin84220903marlin
marls75535163mar_ls
marly106925613mar_ly
marmot10318743marmot
maroon83118203maroon
marque172410503marque
marram10313883marram
marred95421043marred
marrer83716673marrer
marron83717543marron
marrow112812603marrow
marry104821693mar_ry
mars66261873mar__s
marsala939583marsala
marse76231153mar_se
marses84827113marses
marsh105320853mar_sh
marshal1238973marshal
marshy14558333marshy
mart66865983mar__t
marted94425213marted
marten84518263marten
martial92415413martial
martian93514683martian
martin84122523martin
marts77442233mar_ts
martyr1135693martyr
marvel113712003marvel
marvy135014033mar_vy
masa65034723ma__sa
masala8311813masala
mask105227363ma_sk_
masked134316523masked
maskeg13388693maskeg
masker124416103masker
masks115320533ma_sks
massa75518923ma_ssa
matza16311813ma_tza
maxima17568633maxima
maya95824593ma__ya
mazuma1935603mazuma
mazurka2272873mazurka
medaka1336343medaka
merk106027943mer_k_
merks114722403mer_ks
mikra114610313m_ikra
mirk106729503mir_k_
mirker123712693mirker
mirks115122143mir_ks
mirky146315523mir_ky
mirza16410443mir_za
mora66641273mor__a
morula8710473morula
mura65633303mur__a
murk105527253mur_k_
murker123715243murker
murkly15368303murkly
murks114821733mur_ks
murky145216683mur_ky
murra74519083mur_ra
murrha11366453murrha
myrica1336833myrica
nakfa1236093na_kfa
nark85230063nar_k_
narked114116743narked
narks96026033nar_ks
narky126017803nar_ky
paprika1544003paprika
para65242173par__a
park105237493par_k_
parkas125018023parkas
parked134425143parked
parker124121373parker
parks116134463par_ks
parkway1934553parkway
parura8310583parura
pukka10457133_pukka
quokka1841893quokka
sark84938973sar_k_
sarks96632463sar_ks
sarky125521783sar_ky
taka87623593ta__ka
taluka10426773taluka
tanka93817483ta_nka
tarama8412733tarama
tarok97921073tarok_
taroks106115283taroks
tarsia65514273tarsia
tikka835573_tikka
vara75530883var__a
varia85824203var_ia
varna84516173var_na
wark115737773war_k_
warked144421213warked
warks127932403war_ks
zareba1736423zareba
zariba1736983zariba

Search took 6 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.373479064.3
2DLD Change Limit1127162354.78323566.0
3Display Results2352350.0603916.7
 (SQL Overall)1786912355.21634258.2
 
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.