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

125 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
parka11512088(None) 
marka114620791marka
para65242171par_a
park105237491park_
parkas125018021parkas
parks116134461parks
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
mara67444572mar_a
maria75032882maria
mark105138062mark_
markas124717002markas
markka11416592markka
marks115933482marks
nark85230062nark_
narks96026032narks
narky126017802narky
paca85132242pa_ca
pacha126518062pacha
pack125535442pack_
packs135528932packs
paik105726802paik_
paiks114719852paiks
paisa76021072paisa
palea75028662palea
pampa114913422pampa
panda85022612panda
panga85323542panga
papa85827142pa_pa
paprika1544002paprika
par57467022par__
parae76335702parae
paras76143042paras
parch125123002parch
pard76441322par_d
pardah123412822pardah
pardi85723952pardi
pards85634332pards
pardy115523952pardy
pare66760842par_e
pared86946762pared
pareo74632602pareo
parer75839902parer
pares77164482pares
pareu74928742pareu
parge85831852parge
pargo86723722pargo
pariah114320582pariah
parian83223962parian
paris75145942paris
parkade1437582parkade
parked134425142parked
parker124121372parker
parkway1934552parkway
parlay113713992parlay
parle75836162parle
parol74826272parol
parr65731152par_r
parral85517532parral
parrs75928672parrs
parry105323752parry
pars67560792par_s
parse75236992parse
part65967462par_t
partan83820562partan
parts77743372parts
party106630612party
parura8310582parura
parve109824852parve
parvo107719182parvo
pasha105417182pasha
pasta76624532pasta
pawky173810152pawky
perea75026442perea
perk106232842perk_
perks115325802perks
perky145319482perky
pika106322952p_ika
polka11310412polka
pork106929682pork_
porks115124142porks
porky145019332porky
proa66229962p_roa
pucka133412802pucka
pukka10457132pukka
punka114515482punka
purda82914692purda
sark84938972sark_
sarks96632462sarks
sarky125521782sarky
spark114920892spark_
sparks124616362sparks
sparky154511522sparky
taka87623592ta_ka
tanka93817492tanka
vara75530882var_a
varia85824202varia
varna84516172varna
wark115737772wark_
warks127932402warks

Search took 3 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 Limit538001251.79629955.5
3Display Results1251250.0304166.7
 (SQL Overall)1786911252.12284208.8
 
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.