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

154 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
maria7503288(None) 
aria46245421_aria
mafia104418031mafia
mania75634151mania
mara67444571mar_a
marina84623411marina
marka114620791marka
varia85824201varia
agria65517142agria
amarna839792amarna
amia66836902_amia
amnia75918642amnia
amrita8411132amrita
area45843392_area
arias55438022_arias
arid57642712_arid
aril45843022_aril
atria56022342atria
barca91319432barca
baric96125692baric
cardia9916372cardia
carina84325322carina
ceria75125352ceria
coria75828322coria
curia74523772curia
daric85623112daric
facia103218462facia
farina94618232farina
feria85922712feria
garda7316762garda
jarina134014062jarina
karma113415002karma
labia75219012labia
lamia75324322lamia
lari45839152lari_
lariat6629042lariat
laris54737462laris
larva8312482larva
latria62313592latria
maffia14327202maffia
mafias113913572mafias
mafic125615462mafic
magi76329532magi_
magian9312832magian
magic105818652magic
magma104513572magma
maid75537662ma_id
mail65543452ma_il
maim85831492ma_im
main65345522ma_in
mair66133782ma_ir
mairs76228302mairs
malaria9313692malaria
malic94525662malic
mama86231592ma_ma
mamba116317522mamba
mamie95826002mamie
mamma86317912mamma
mana65341962ma_na
manga85026202manga
maniac103917972maniac
manias84029032manias
manic94629442manic
manila84518302manila
manna75522542manna
manta75629912manta
mar57965952mar__
maraca10314152maraca
maras75443292maras
marc87034632mar_c
march125622892march
marcs95726622marcs
mare64759332mar_e
mares76457632mares
margay12310592margay
marge85328332marge
margin94016842margin
marimba1354982marimba
marinas93519382marinas
marine84230402marine
marish114319052marish
marital92314182marital
mark105138062mar_k
markas124717002markas
markka11416592markka
marks115933482marks
marl66341622mar_l
marlin84220902marlin
marls75535162marls
marly106925612marly
marram10313882marram
marry104821692marry
mars66261872mar_s
marse76231152marse
marsh105320852marsh
mart66865982mar_t
martial92415412martial
martian93514682martian
martin84122522martin
marts77442232marts
marvy135014032marvy
masa65034722ma_sa
massa75518922massa
matin75132852matin
matrix1539842matrix
matza16311812matza
mavie104722562mavie
mavin105722952mavin
mavis105622722mavis
maxi137023562maxi_
maxim165216002maxim
maxima17568632maxima
maxis145721562maxis
maya95824592ma_ya
mbira977972mbira
media84721712media
merit7339182merit
milia72719572milia
miri66730372miri_
mirin75023152mirin
mirza16410442mirza
moira71012022moira
mora66641272mor_a
mura65633302mur_a
murid84520582murid
murra74519082murra
myriad1235912myriad
myrica1336832myrica
naira5314742naira
narial6317952narial
naric76824172naric
naris55735292naris
noria55722182noria
para65242172par_a
pariah114320582pariah
parian83223962parian
paris75145942paris
parka115120882parka
raia46638382ra_ia
ria36745502__ria
sari45444042sari_
sarin55239252sarin
saris54544952saris
sharia93116732sharia
stria55723212stria
tafia84215492tafia
tarsia65514272tarsia
vara75530882var_a
varias95019902varias
varix154313512varix
varna84516172varna
zamia165115212zamia
zariba1736982zariba
zoaria1548382zoaria

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 Limit538001541.45337026.8
3Display Results1541540.0305133.3
 (SQL Overall)1786911541.79699493.9
 
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.