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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
mark105138061mark_
marka114620791marka
market123226041market
marks115933481marks
mart66865981mar_t
ark77044962_ark_
arks85936872_arks
art38679142_ar_t
bark106242152bark_
barks115735812barks
barky145721612barky
carat75048792carat
caret75360562caret
cark105539272cark_
carks115534212carks
cart66570342car_t
dark95133212dark_
darks106727872darks
darky136018832darky
dart55857872dar_t
fart76860562far_t
hark115237392hark_
harks126333432harks
hart76865772har_t
imaret81121232imaret
karat96837592karat
karst97228992karst
kart86750802kar_t
lark85733862lark_
larks95227812larks
larky125218872larky
mack125733652mack_
macks135127602macks
magot8326392magot
maist75535682maist
make105537892ma_ke
mako105622362ma_ko
malt66254812ma_lt
manat76039992manat
mar57965952mar__
mara67444572mar_a
maras75443292maras
marc87034632mar_c
march125622892march
marcs95726622marcs
mare64759332mar_e
mares76457632mares
marge85328332marge
maria75032882maria
markas124717002markas
marked133921622marked
marker124420392marker
markets133314032markets
markka11416592markka
markup1436902markup
marl66341622mar_l
marls75535162marls
marly106925612marly
marmot10318742marmot
marry104821692marry
mars66261872mar_s
marse76231152marse
marsh105320852marsh
marts77442232marts
marvy135014032marvy
mask105227362mask_
masks115320532masks
mast65959962ma_st
mat58083942ma__t
matt65752662ma_tt
maut65448452ma_ut
mayst106622672mayst
merit7339182merit
merk106027942merk_
merks114722402merks
mirk106729502mirk_
mirks115122142mirks
mirky146315522mirky
mort66758832mor_t
murk105527252murk_
murks114821732murks
murky145216682murky
nark85230062nark_
narks96026032narks
narky126017802narky
park105237492park_
parka115120882parka
parks116134462parks
part65967462par_t
sark84938972sark_
sarks96632462sarks
sarky125521782sarky
smart75834092smar_t
tarot55943932tarot
tart47566182tar_t
wark115737772wark_
warks127932402warks
wart77866082war_t

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.313570897.8
2DLD Change Limit53800981.50035866.7
3Display Results98980.0137538.5
 (SQL Overall)178691981.82697859.3
 
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.