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

320 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
morts7553356(None) 
borts76735451borts
forts86034451forts
marts77442231marts
moats75827641moats
molts76032091molts
moots75831661moots
moras76438781moras
mores76249641mores
morns75527441morns
mors65950061mor_s
mort66758831mort_
mosts76028541mosts
mots66853161mo_ts
motts76527001motts
orts46538331_orts
ports75934591ports
sorts54536661sorts
torts56138121torts
worts88631181worts
aborts84916182aborts
airts55626342airts
amort75832202amort_
aorta55922572aorta
aortas65417782aortas
arts49650262_arts
boarts84716872boarts
boats75635152boats
bolts76232112bolts
boots75837972boots
boras75938302boras
bores76448252bores
borks115727702borks
bort65960962bort_
borty105522832borty
bortz165722202bortz
bots66453952bo_ts
botts75224862botts
bouts75131312bouts
carts78946292carts
coats75635002coats
colts76633292colts
coots75636842coots
cords86030622cords
cores76361852cores
corks116028272corks
corms95626222corms
corns76034762corns
corps95927042corps
cors66656442cor_s
costs77231142costs
cots68054842co_ts
courts84216172courts
darts67635732darts
dirts66824462dirts
doats65224882doats
doits66223672doits
dolts65626312dolts
dorks105724442dorks
dorms85723842dorms
dorps85419222dorps
dorrs65520592dorrs
dors56747602dor_s
dorty96220812dorty
dots55647662do_ts
farts88336842farts
fonts86124752fonts
foots85528282foots
forbs105720802forbs
fords95328182fords
fores85847102fores
forks125324682forks
forms105327052forms
fort76456442fort_
forte86131462forte
fortes95327182fortes
forth116222672forth
fortis95418612fortis
forty114824272forty
girts65423622girts
goats65527302goats
gores65740372gores
gorms85619592gorms
gorps85316992gorps
gouts64826172gouts
grots65025852grots
harts88441592harts
holts85627912holts
hoots84830252hoots
horas86333102horas
horns86125332horns
horst85833512horst
horsts95817512horsts
hosts85526702hosts
hots78349332ho_ts
hurts86922822hurts
imports11309622imports
jolts125018882jolts
jots116336142jo_ts
karts97630112karts
koras95927112koras
korats105416062korats
kors85933012kor_s
lofts85518362lofts
loots55431422loots
lords64923502lords
lores55045402lores
loris55329152loris
lots47652092lo_ts
louts56330272louts
malts76331752malts
maras75443292maras
marcs95726622marcs
mares76457632mares
marks115933482marks
marls75535162marls
mars66261872mar_s
mart66865982mart_
masts77035762masts
mats65460292m_ats
matts76829182matts
mauts75927192mauts
meats75034052meats
meets74224612meets
melts74930102melts
mercs96020452mercs
meres75143572meres
merits8320872merits
merks114722402merks
merls77423902merls
milts75430712milts
mints76834042mints
mires75640882mires
mirks115122142mirks
mirs66940572mir_s
mirth106418892mirth
mirths114912992mirths
mists76633902mists
mitts75523752mitts
moans74624372moans
moas65545342mo_as
moat66352032moat_
mobs85737372mo_bs
mocks135023822mocks
mocs85834902mo_cs
modes85537412modes
mods77945052mo_ds
modus85417202modus
mogs75439332mo_gs
moils76125752moils
moires8915632moires
moist76033582moist
mojos145314462mojos
mokes114631032mokes
molas75132092molas
molds85324832molds
moles74747922moles
molls75129782molls
mols65948572mo_ls
molt66356162molt_
molto75619602molto
momes95134472momes
moms86539482mo_ms
momus96116112momus
monas74732152monas
monks116123392monks
monos75930862monos
mons68152262mo_ns
monte75829772monte
montes84226932montes
month104818422month
months113812932months
moods85224622moods
mools76027172mools
moons75331002moons
moors74923142moors
moos66051302mo_os
moot67653622moot_
mopes95134982mopes
mops85940132mo_ps
mor56855002mor__
mora66641272mor_a
morae75831192morae
moral75533432moral
morals85324642morals
morass84614502morass
moray105423792moray
morays114613882morays
more67154522mor_e
morel75729092morel
morels84820022morels
morn66237562mor_n
moron76925422moron
morons84919542morons
morose85116242morose
morph121712512morph
morphs13149432morphs
morris83814732morris
morro73216952morro
morros83714672morros
morse76032702morse
mortal84616852mortal
mortals93914012mortals
mortar83812042mortar
mortars93411522mortars
mortise9713532mortise
mos57067122mo__s
mosks116117002mosks
moss67641032mo_ss
most66554202most_
moste75925082moste
mot57279422mo_t_
mote67048082mo_te
motes75944002motes
motets84216192motets
moth96731332mo_th
moths106021552moths
mott66648442mo_tt
motte75526972motte
mottes85523692mottes
motto76119512motto
mottos84615242mottos
moues75732842moues
moults84713702moults
mounts84115072mounts
mourns84111012mourns
mouth105420292mouth
mouths115214532mouths
moves106128422moves
mows96340832mo_ws
moxas145014402moxas
mozos165516332mozos
muras75329582muras
mures75937222mures
murks114821732murks
murrs75521302murrs
musts75527442musts
muts64839982m_uts
mutts75120252mutts
nerts55924982nerts
noris54928272noris
norms76019312norms
north86018272north
norths96812322norths
nowts86915862nowts
oats46554212_oats
omits75018262omits
oots46446442_oots
opts68124742_opts
orbs66626252_orbs
orcs67025432_orcs
ores46056682_ores
ors35750112_or_s
ort39465232_ort_
outs45746962_outs
parts77743372parts
poets76024442poets
pores75849032pores
porks115124142porks
porns75527342porns
port66059632port_
posts75228782posts
pots66452362po_ts
pouts75530322pouts
roots55933672roots
rots46454092ro_ts
routs57133412routs
shorts95321742shorts
skorts104211302skorts
smarts86218002smarts
smolts84411882smolts
snorts64116502snorts
softs85019232softs
soots55536212soots
soras55041012soras
sorbs75022102sorbs
sords64527802sords
sores55454282sores
sorns55028422sorns
sort46264812sort_
sorta57125412sorta
sorus54527582sorus
sots45552452so_ts
sports84619182sports
tarts57242022tarts
tofts84919242tofts
toits55327472toits
toots55331872toots
toras55540372toras
torcs75123762torcs
tores55352672tores
toros54336192toros
torrs53923562torrs
tors46157382tor_s
tort46967462tort_
torta55925352torta
tortas64918252tortas
torte55431702torte
tortes64826052tortes
torus54329762torus
tots46654122to_ts
touts54830392touts
trots56629942trots
verts85724732verts
volts85421292volts
warts814840402warts
whorts125111432whorts
wonts87621542wonts
words95425072words
works125621902works
worms105320762worms
worst86330132worst
worsts96014332worsts
wort76654752wort_
worth117120522worth
worths127812892worths
wots76342892wo_ts
yores85031322yores
yurts87216532yurts
zoris145320012zoris

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 Limit538003201.50035866.7
3Display Results3203200.0933440.9
 (SQL Overall)1786913201.88994595.6
 
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.