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 “marka” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

116 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
marka11462079(None) 
mara67444571mar_a
maria75032881maria
mark105138061mark_
markas124717001markas
markka11416591markka
marks115933481marks
parka115120881parka
amarna839792amarna
arak86929572_arak
area45843392_area
aria46245422_aria
ark77044962_ark_
arks85936872_arks
babka137812912babka
barca91319432barca
bark106242152bark_
barks115735812barks
barky145721612barky
burka114617692burka
cark105539272cark_
carks115534212carks
charka154011702charka
dark95133212dark_
darks106727872darks
darky136018832darky
garda7316762garda
haika125313792haika
hark115237392hark_
harks126333432harks
kaka76518682ka_ka
karma113415002karma
lark85733862lark_
larks95227812larks
larky125218872larky
larva8312482larva
mack125733652mack_
macks135127602macks
mafia104418032mafia
magma104513572magma
makar115614972ma_kar
make105537892ma_ke
mako105622362ma_ko
mama86231592ma_ma
mamba116317522mamba
mamma86317912mamma
mana65341962ma_na
manga85026202manga
mania75634152mania
manna75522542manna
manta75629912manta
mar57965952mar__
maraca10314152maraca
maras75443282maras
marc87034632mar_c
march125622892march
marcs95726622marcs
mare64759332mar_e
mares76457632mares
margay12310592margay
marge85328332marge
marina84623412marina
marked133921622marked
marker124420392marker
market123226042market
markkaa12373922markkaa
markkas12356082markkas
markup1436902markup
marl66341622mar_l
marls75535162marls
marly106925612marly
marram10313882marram
marry104821692marry
mars66261872mar_s
marse76231152marse
marsh105320852marsh
mart66865982mar_t
marts77442232marts
marvy135014032marvy
masa65034722ma_sa
mask105227362mask_
masks115320532masks
massa75518922massa
matza16311812matza
maya95824592ma_ya
mazurka2272872mazurka
merk106027942merk_
merks114722402merks
mikra114610312mikra
mirk106729502mirk_
mirks115122142mirks
mirky146315522mirky
mirza16410442mirza
mora66641272mor_a
mura65633292mur_a
murk105527252murk_
murks114821722murks
murky145216682murky
murra74519082murra
nark85230062nark_
narks96026032narks
narky126017802narky
para65242172par_a
park105237492park_
parkas125018022parkas
parks116134462parks
sark84938972sark_
sarks96632462sarks
sarky125521782sarky
taka87623592ta_ka
tanka93817482tanka
vara75530882var_a
varia85824202varia
varna84516172varna
wark115737772wark_
warks127932402warks

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538001161.65632487.9
3Display Results1161160.0303866.7
 (SQL Overall)1786911161.98290156.9
 
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.