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 “maar” 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
maar6602505(None) 
haar77323491haar
maars74621631maars
mair66133761mair
makar115614971makar
malar76424441malar
mar57965941m_ar
mara67444561mara
aa219179952_aa_
aah616252962_aah
aal39058672_aal
aas310975392_aas
afar76720782afar
agar58726412agar
air38058392_air
ajar116217702ajar
alar46340072alar
ama510853302ama_
amah98927482amah
amas67746292amas
amir65129742amir
ar211379382__ar
baa510650422baa_
baal67033112baal
baas66844672baas
bar58070552_bar
bazar163816002bazar
bear66844642bear
boar66134292boar
car59165562_car
carr65434702carr
char95132152char
czar156013132czar
damar84117732damar
dear55343602dear
ear36867882_ear
embar94011592embar
fair76332522fair
far67762602_far
fear75337792fear
fiar76427332fiar
gar47259902_gar
gaur56723352gaur
gazar154612982gazar
gear55934972gear
gnar56021382gnar
guar56923292guar
haaf106227732haaf
haars85620472haars
hair76330142hair
hear76143882hear
hoar76729162hoar
izar136616012izar
jar107646152_jar
kaas86531842kaas
kabar114815552kabar
kbar106514652kbar
knar85818722knar
kyar116916842kyar
laari54415712laari
lahar83114262lahar
lair45934152lair
lar37967532_lar
lazar144113642lazar
lear47045952lear
liar47229682liar
ma410060652m_a_
mabe85733342mabe
mac78053922m_ac
macaw12311762macaw
mace87345782mace
macer912126942macer
mach116134472mach
mack125733642mack
macro94718172macro
macs86742502macs
mad68958702m_ad
madam10316222madam
made75440232made
madre85720172madre
mads76845362mads
mae57659102m_ae
maes66948392maes
mag67956472m_ag
mage75739122mage
magi76329522magi
mags75444522mags
maid75537632maid
mail65543432mail
maim85831472maim
main65345502main
mairs76228292mairs
major145212922major
makars124612632makars
make105537882make
maker114127812maker
mako105622352mako
malars85020682malars
male66052292male
mall64639362mall
malm85129972malm
malt66254802malt
mama86231582mama
mamas95930772mamas
man57465852m_an
mana65341942mana
manas76240422manas
manat76039982manat
mane65052012mane
mano66536792mano
manor78023922manor
mans66354532mans
many95731842many
map77255112m_ap
maps86141042maps
maras75443282maras
marc87034622marc
mare64759322mare
mark105138052mark
marl66341612marl
marry104821692marry
mars66261862mars
mart66865972mart
mas58175812m_as
masa65034712masa
masas75630412masas
maser75029972maser
mash96039392mash
mask105227352mask
mass66044932mass
mast65959952mast
mat58083932m_at
mate65154212mate
mater74438862mater
math95437442math
mats65460282mats
matt65752652matt
maud75325392maud
maul64830712maul
maun65727202maun
maut65448442maut
maw87050092m_aw
mawn94424132mawn
maws96437132maws
max129045442m_ax
maxi137023552maxi
may88757622m_ay
maya95824582maya
mayan105616902mayan
mayas105924382mayas
mayo96524292mayo
mayor106616622mayor
mays96940022mays
mazard1838762mazard
maze155434972maze
mazer165722422mazer
mazy186419692mazy
mead75531602mead
meal65643172meal
mean65538082mean
meat66359602meat
mir57046762m_ir
moa57249182moa_
moan65832012moan
moas65545342moas
moat66352032moat
molar75223092molar
moor66628552moor
mor56855002m_or
mora66641272mora
mura65633292mura
murr65225132murr
mylar105311532mylar
naan47621932naan
navar83912732navar
near45236502near
oar37057952_oar
osar46820952osar
pair66031512pair
par57467022_par
para65242172para
parr65731152parr
pear69745232pear
radar61316722radar
rear45644552rear
roar46328572roar
scar66434202scar
sear47353842sear
smear74416392smear
soar46838672soar
spar65433302spar
star48037762star
tahr75217152tahr
talar56225382talar
tar37570692_tar
tatar56122062tatar
tear45242882tear
tsar47819802tsar
tzar136315372tzar
vair75624142vair
var66148332_var
vara75530882vara
wair75830052wair
war67262422_war
waur76819902waur
wear75836722wear
yar67253832_yar
year76534252year

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.0602978183.3
2DLD Change Limit298722080.92332364.0
3Display Results2082080.0464521.7
 (SQL Overall)1786912081.029173655.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.