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

379 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
mart6686598(None) 
art38679141_art
cart66570341cart
dart55857871dart
fart76860561fart
hart76865771hart
kart86750821kart
malt66254811malt
mar57965951mar_
mara67444581mara
marc87034631marc
mare64759331mare
mark105138061mark
marl66341621marl
mars66261871mars
marts77442231marts
mast65959961mast
mat58083941ma_t
matt65752661matt
maut65448451maut
mort66758831mort
part65967461part
smart75834091smart
tart47566181tart
wart77866081wart
act59557842_act
aft66849012_aft
airt45757792airt
ait38093912_ait
alt36467962_alt
amort75832202amort
ant37270792_ant
apart74330672apart
apt57352542_apt
ar211379382_ar_
arb510448422_arb
arc510250902_arc
are37874572_are
arf67453372_arf
ark77044962_ark
arm58449632_arm
ars37670932_ars
arts49650262_arts
arty77531312_arty
at212393402_a_t
att35454652_att
baht96740012baht
bait66556002bait
bar58070552bar_
barb85240062barb
bard75648862bard
bare65460522bare
barf95844412barf
bark106242152bark
barm86739612barm
barn66444642barn
bars66564092bars
bast66362412bast
bat510988952ba_t
batt65053872batt
boart78835932boart
bort65960962bort
brat66055542brat
cant66362032cant
car59165562car_
carat75048802carat
carb85143162carb
card710245872card
care66968372care
caret75360562caret
cark105539272cark
carl65144782carl
carn66245432carn
carp85139812carp
carr65434702carr
cars67364762cars
carte75940422carte
carts78946292carts
cast67159902cast
cat58282342ca_t
chart105038282chart
curt67051712curt
daft85537252daft
darb76033532darb
dare55848862dare
dark95133212dark
darn56434622darn
darts67635732darts
daut56443562daut
dawt85435942dawt
dirt55550392dirt
drat56247832drat
ear36867882ear_
earl45838142earl
earn46737552earn
ears46356592ears
earth85023052earth
east46659102east
eat36989052ea_t
fact97142542fact
far67762602far_
fard85639062fard
fare76354462fare
farl76338552farl
farm95934542farm
faro76136922faro
farts88336842farts
fast77052312fast
fat68178082fa_t
fort76456442fort
frat75648542frat
gait56150192gait
gar47259902gar_
garb75332672garb
gars55750742gars
garth94720222garth
gast56052562gast
gat46880512ga_t
girt56646432girt
grat55651282grat
haet75659502haet
haft105941842haft
halt76056302halt
hant75461592hant
hard85443502hard
hare76255732hare
hark115237392hark
harl75740002harl
harm95637802harm
harp96134292harp
harts88441592harts
hast76259482hast
hat67289962ha_t
haut75949732haut
heart85440742heart
hurt77142572hurt
imaret81121232imaret
impart102715142impart
jar107646152jar_
jarl115828132jarl
jars117338352jars
karat96837612karat
karn86129432karn
karst97229002karst
karts97630122karts
kat77468302ka_t
lar37967532lar_
lard56742002lard
lari45839152lari
lark85733862lark
lars46956572lars
last46260322last
lat37593402la_t
lyart85121882lyart
ma410060662ma__
maar66025062maar
maars74621632maars
mabe85733362mabe
mac78053932ma_c
mace87345792mace
mach116134482mach
mack125733652mack
macro94718172macro
macs86742512macs
mad68958722ma_d
made75440252made
madre85720172madre
mads76845382mads
mae57659112ma_e
maes66948402maes
mag67956482ma_g
mage75739132mage
magi76329532magi
magot8326392magot
mags75444532mags
maid75537672maid
mail65543452mail
maim85831492maim
main65345522main
mair66133782mair
mairs76228302mairs
maist75535682maist
make105537892make
mako105622362mako
male66052302male
mall64639372mall
malm85129982malm
malts76331752malts
malty106721702malty
mama86231602mama
man57465872ma_n
mana65341962mana
manat76039992manat
mane65052032mane
mano66536812mano
mans66354552mans
manta75629912manta
many95731862many
map77255122ma_p
maps86141052maps
maras75443302maras
march125622892march
marcs95726622marcs
mares76457632mares
marge85328332marge
maria75032892maria
marka114620802marka
market123226042market
marks115933482marks
marls75535162marls
marly106925612marly
marmot10318752marmot
marry104821692marry
marse76231152marse
marsh105320852marsh
marted94425212marted
marten84518262marten
martin84122522martin
martyr1135692martyr
marvy135014032marvy
mas58175822ma_s
masa65034722masa
mash96039402mash
mask105227362mask
mass66044942mass
masts77035762masts
mate65154222mate
math95437452math
mats65460292mats
matte75626842matte
matts76829182matts
maud75325402maud
maul64830722maul
maun65727212maun
mauts75927192mauts
maw87050102ma_w
mawn94424142mawn
maws96437142maws
max129045452ma_x
maxi137023562maxi
may88757632ma_y
maya95824592maya
mayo96524302mayo
mays96940032mays
mayst106622672mayst
maze155434982maze
mazy186419702mazy
meant76537212meant
meat66359602meat
meet65350552meet
melt65752892melt
merc87225622merc
mere67244442mere
merit7339182merit
merk106027942merk
merl65830972merl
met56072432m_et
milt65455822milt
mint66758072mint
mir57046782mir_
mire66748242mire
miri66730382miri
mirk106729512mirk
mirs66940582mirs
mirth106418892mirth
miry96326762miry
mist66154542mist
mitt66145502mitt
mixt136831932mixt
moat66352032moat
molt66356162molt
moot67653622moot
mor56855002mor_
mora66641272mora
more67154522more
morn66237562morn
mors65950062mors
morts75533562morts
most66554202most
mot57279422m_ot
mott66648442mott
mura65633302mura
mure65941332mure
murk105527252murk
murr65225132murr
must65145442must
mut58357182m_ut
mutt65739402mutt
narc67127952narc
nard56634452nard
nark85230062nark
nary76931222nary
oar37057952oar_
oars46846032oars
oast47156322oast
oat39888262oa_t
ort39465232_ort
pact86648722pact
pant66061262pant
par57467022par_
para65242182para
pard76441322pard
pare66760842pare
park105237492park
parr65731152parr
pars67560792pars
parts77743372parts
party106630612party
past65959012past
pat58089462pa_t
peart76440752peart
pert66759322pert
port66059632port
prat65952042prat
qat125253332qa_t
quart144027852quart
raft76245912raft
rant45864682rant
rapt67245312rapt
rare45348432rare
rat37892742ra_t
salt45758522salt
sard55344242sard
sari45444042sari
sark84938972sark
sat36288482sa_t
scart76139772scart
smalt74729332smalt
smarm95517602smarm
smarts86218002smarts
smarty115013792smarty
sort46264812sort
start55642312start
swart86234642swart
tact67349032tact
tar37570692tar_
tare45957622tare
tarn46842722tarn
taro46846912taro
tarot55943932tarot
tarp66936422tarp
tars46763952tars
tarts57242022tarts
tarty86328182tarty
tat37690292ta_t
taut47048962taut
tort46967462tort
var66148332var_
vara75530892vara
vars75742072vars
vary105226062vary
vast75045122vast
vat67863452va_t
vert77249372vert
waft106139002waft
wait75553692wait
want76156172want
war67262422war_
ward86542252ward
ware76254722ware
wark115737772wark
warm95935682warm
warn75239322warn
warp95635002warp
wars78659802wars
warts814840402warts
warty119323822warty
wary106740012wary
wast75655852wast
wat67378922wa_t
watt75545412watt
wert79749822wert
wort76654752wort
yar67253832yar_
yard85633252yard
yare75636942yare
yarn75230042yarn
yurt76435042yurt
zarf166929122zarf

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 Filter178691298720.283631417.0
2DLD Change Limit298723790.78038297.4
3Display Results3793790.0934075.3
 (SQL Overall)1786913791.156154577.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.