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

208 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
marses8482711(None) 
arses55733871_arses
carses85233651carses
manses84225511manses
mares76457631mar_es
marges94525711marges
marse76231151marse_
marshes123615371marshes
masses85028711masses
parses85534701parses
amasses93912852amasses
amuses85117942amuses
apses76823912_apses
ares45871022_ar_es
arises65233802_arises
arles56735742_arles
arse46539272_arse_
arsis55722422_arsis
asses55629282_asses
baases85218012baases
barbes104526232barbes
bardes95026932bardes
bares75457132bar_es
barges94528252barges
barres84427542barres
baryes116218502baryes
bases75644352ba_ses
basses85428302basses
birses84717732birses
burses84425512burses
cares77369182car_es
caress85720262caress
caries85147622caries
carles85435082carles
carse74934332carse_
cartes86239472cartes
carves115128452carves
cases75048382ca_ses
causes88026472causes
corses84433462corses
crases85532312crases
curses85328272curses
daises74318982daises
dares66146702dar_es
eases56041612ea_ses
erases64425402erases
erses55826802_erses
farces115223322farces
fares85852872far_es
farles96025782farles
gases65633992ga_ses
gasses75724782gasses
gorses74723292gorses
hanses95022632hanses
hares86255542har_es
hawses125113992hawses
hearses104414532hearses
horses94729342horses
karsts106012942karsts
lapses85217692lapses
larees65323112larees
lares54852632lar_es
larges74824232larges
lases54944762la_ses
lasses64827592lasses
mabes96331532ma_bes
maces97139962ma_ces
maches134827232maches
macles107023222macles
madrases112610002madrases
madres93718182madres
maes66948402ma__es
mages85036022ma_ges
mahoes11313102mahoes
mailes84329112mailes
maists85817572maists
maizes175115732maizes
makes115336852ma_kes
males75049792ma_les
mamies104626242mamies
manes76648962ma_nes
manges94628942manges
manse75528232manse_
mantes84430782mantes
maples104819422maples
maras75443292mar_as
marbles114516652marbles
marcel103714852marcel
marcels113212372marcels
marches143921172marches
marcs95726622mar_cs
mare64759332mar_e_
marge85328332marge_
marines93928012marines
marishes13512552marishes
markas124717002markas
marked133921622marked
marker124420392marker
markers133516102markers
market123226042market
markets133314032markets
marks115933482mar_ks
marled95523162marled
marls75535162mar_ls
marques182610862marques
marred95421042marred
marrer83716672marrer
marrers93414312marrers
marries93825282marries
mars66261872mar__s
marsh105320852mars_h
marshy14558332marshy
marted94425212marted
marten84518262marten
martens93714952martens
marts77442232mar_ts
marvel113712002marvel
marvels123810092marvels
masas75630412ma_sas
maser75029972ma_ser
masers84623452ma_sers
mashes115030002mashes
masks115320532ma_sks
mass66044942ma_s_s
massas85116462massas
masse75125292masse_
massed94421322massed
masts77035762ma_sts
mates75251362ma_tes
matres84522232matres
mattes85624532mattes
mauves113811552mauves
mavies114923192mavies
mavises122812992mavises
maxes145629532ma_xes
maybes1339242maybes
mazes165632172ma_zes
menses84222452menses
merces105720742merces
merdes94518602merdes
meres75143572mer_es
merges94122492merges
merises93421422merises
merles85322762merles
messes84924342messes
mioses84318852mioses
mires75640882mir_es
mises74740562m_ises
misses85130872misses
mores76249642mor_es
morse76032702morse_
morsel85815892morsel
morsels94112652morsels
mosses85527682mosses
mouses85531422mouses
mures75937222mur_es
murres85019042murres
muses75134302m_uses
musses84624782musses
myases113711552myases
myoses114013842myoses
nares55544152nar_es
nurses63919352nurses
oases55330982oa_ses
pares77164482par_es
pareses94718882pareses
parges94529542parges
paries84742512paries
parises94827182parises
parles86334402parles
parse75236992parse_
parsec105914482parsec
parsecs11429922parsecs
parsed96323892parsed
parser84822372parser
parsers94118152parsers
pases75346502pa_ses
passes86030472passes
pauses84621472pauses
perses85428062perses
prases84429022prases
purses84826372purses
raises64826542raises
rares55247442rar_es
rases55447212ra_ses
sarees65329942sarees
sarges75128592sarges
saroses73619332saroses
sarsen6314232sarsen
sarsens7311392sarsens
sasses64124392sasses
tares57456562tar_es
targes74524592targes
tarres64723042tarres
tarsus6310512tarsus
tasses64826762tasses
tawses94913192tawses
torses64727952torses
urases63723562urases
valses94514612valses
varies94330872varies
varuses10310622varuses
varves124414782varves
vases84626262va_ses
verses94223762verses
wares88250582war_es
warsles103413642warsles
worses95522952worses

Search took 4 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 Filter178691825510.360496363.9
2DLD Change Limit825512082.70330540.5
3Display Results2082080.0603466.7
 (SQL Overall)1786912083.12357217.7
 
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.