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

515 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
mate6515422(None) 
ate37059241_ate
bate66552421bate
cate66254601cate
date56443321date
fate75444281fate
gate55746571gate
hate78450171hate
late47560481late
mabe85733361mabe
mace87345791mace
made75440241made
mae57659111ma_e
mage75739131mage
make105537891make
male66052301male
mane65052031mane
mare64759331mare
mat58083941mat_
mated85537781mated
mater74438861mater
mates75251361mates
matey107022661matey
math95437451math
mats65460291mats
matt65752661matt
matte75626841matte
maze155434981maze
mete64438131mete
mite66249411mite
mote67048081mote
mute65136871mute
pate65350461pate
rate45458761rate
sate45556101sate
tate44748601tate
abate76627842abate
ace59656832_ace
ae212590292_a_e
agate66525152agate
age47154332_age
alate55340322alate
ale36572342_ale
amaze166016602amaze
amie66339852amie
ane37866952_ane
ante46538902ante
ape57251182_ape
are37874572_are
at212393402_at_
ates45047922_ates
att35454652_att
ave67748702_ave
awe67746622_awe
axe108239492_axe
aye67151762_aye
babe86835822babe
bade75140882bade
bake105637512bake
bale66353842bale
bane65250432bane
bare65460522bare
base64847022base
baste74829982baste
bat510988952bat_
bated85935532bated
bates75846342bates
bath95940082bath
bathe105822882bathe
bats66962332bats
batt65053872batt
bite66547002bite
blate75933782blate
bute66739672bute
byte96521812byte
cade76443912cade
cafe95230322cafe
cage75339062cage
cake105439962cake
came87648752came
cane66653122cane
cape87242782cape
care66968372care
carte75940422carte
case65848082case
caste75932362caste
cat58282342cat_
cater74840722cater
cates75951892cates
cats66356342cats
cave95941262cave
cete64934782cete
cite65640342cite
comate104124842comate
cote66648732cote
crate76537402crate
cute66440452cute
dace76934922dace
dale55643982dale
dame77140312dame
dare55848862dare
data56026652data
dated75530992dated
dater65332312dater
dates65639152dates
dato56129942dato
daze147327232daze
dite55547552dite
dote55442882dote
ease45042332ease
eat36989052eat_
eaten55323052eaten
eater54639842eater
eath75735662eath
eats47054872eats
eave75733582eave
elate55335882elate
emote75421192emote
enate54428142enate
face96140122face
fade85736342fade
fake115534942fake
fame95639392fame
fane75343572fane
fare76354462fare
fat68178082fat_
fated95632132fated
fates85139232fates
fats76252502fats
fave105532962fave
faze165630042faze
fete75734922fete
gae46457702ga_e
gage65936102gage
gale56347322gale
game76644322game
gane55145302gane
gape75134512gape
gat46880512gat_
gated75329772gated
gater64533652gater
gates65939512gates
gats56753442gats
gave84634052gave
gaze145032412gaze
gite55438612gite
grate64932882grate
hade85440192hade
hae67364002ha_e
haet75659502haet
hake115637842hake
hale76052832hale
hamate113319832hamate
hame97043132hame
hare76255732hare
haste85927862haste
hat67289962hat_
hated95734022hated
hater85034752hater
hates86742572hates
hath105933912hath
hats76858252hats
haute89521612haute
have106137072have
haze164833392haze
humate113214442humate
hyte109018942hyte
image81411292image
inmate82917362inmate
irate55627982irate
jade125325442jade
jake155925772jake
jane115031482jane
jape134923422jape
jato115822682jato
jete115927252jete
jute115327892jute
kae76744542ka_e
kale86533752kale
kame105728232kame
kane85133972kane
kat77468292kat_
kata85626022kata
kats85944332kats
kite85338232kite
kyte117017762kyte
lace66848472lace
lade56345982lade
lake85741602lake
lame66849292lame
lane45153332lane
lase46148512lase
lat37593402lat_
lated65240672lated
laten54328342laten
later54843922later
latex124717112latex
lath76640382lath
lathe85626712lathe
lati46438272lati
latke94817092latke
lats45962702lats
latte55426302latte
latu47934182latu
lave75642142lave
laze136235052laze
lite47054542lite
lute46341012lute
ma410060662ma__
maar66025062maar
mabes96331532mabes
mac78053932ma_c
maced108528692maced
macer912126942macer
maces97139962maces
mach116134482mach
mache125925302mache
mack125733652mack
macle96127002macle
macs86742512macs
mad68958712ma_d
madre85720172madre
mads76845372mads
maes66948402maes
mag67956482ma_g
mages85036022mages
magi76329532magi
mags75444532mags
mahoe10315572mahoe
maid75537662maid
mail65543452mail
maile75232222maile
maim85831492maim
main65345522main
mair66133782mair
maize164618562maize
maker114127812maker
makes115336852makes
mako105622362mako
malate84624552malate
males75049792males
mall64639372mall
malm85129982malm
malt66254812malt
malted94819862malted
malts76331752malts
malty106721702malty
mama86231592mama
mamey125418832mamey
mamie95826002mamie
man57465872ma_n
mana65341962mana
maned86634102maned
manes76648962manes
mange84930192mange
mano66536812mano
mans66354552mans
manse75528232manse
manta75629912manta
mantel84317972mantel
mantes84430782mantes
mantle84420922mantle
many95731862many
map77255122ma_p
maple95521142maple
maps86141052maps
mar57965952ma_r
mara67444572mara
marc87034632marc
mares76457632mares
marge85328332marge
mark105138062mark
marl66341622marl
mars66261872mars
marse76231152marse
mart66865982mart
marted94425212marted
marten84518262marten
marts77442232marts
mas58175822ma_s
masa65034722masa
maser75029972maser
mash96039402mash
mask105227362mask
mass66044942mass
masse75125292masse
mast65959962mast
masted94025802masted
master84831342master
masts77035762masts
match125621102match
maters85032392maters
mateys115610942mateys
maths105624022maths
matier84321522matier
matin75132852matin
matres84522232matres
matted94521412matted
matter84325342matter
mattes85624532mattes
matts76829182matts
mature8313462mature
matza16311812matza
matzo16312892matzo
maud75325402maud
maul64830722maul
maun65727212maun
maut65448452maut
mauts75927192mauts
mauve104013272mauve
maven104816892maven
mavie104722562mavie
maw87050102ma_w
mawed115824742mawed
mawn94424142mawn
maws96437142maws
max129045452ma_x
maxed155821192maxed
maxes145629532maxes
maxi137023562maxi
may88757632ma_y
maya95824592maya
maybe12311132maybe
mayed115522402mayed
mayo96524302mayo
mays96940032mays
mazed175523872mazed
mazer165722422mazer
mazes165632172mazes
mazy186419702mazy
me47748332m__e
meat66359602meat_
meated94222402meated
meats75034052meats
meaty107021312meaty
meet65350552meet
meme85330552meme
mere67244442mere
met56072432met_
meta65932412meta
metate82720532metate
meted85424432meted
meter75130322meter
metes74736212metes
meth95827842meth
metre74821302metre
meze154420902meze
mice87442232mice
mike105535292mike
mile66352572mile
mime85736402mime
mine67256172mine
mire66748232mire
misate81222692misate
mise66043582mise
miter75734792miter
mites75141802mites
mitre75522422mitre
mitt66145492mitt
mity95528212mity
moat66352032moat_
moated94819002moated
moats75827642moats
mode75840302mode
moke106234222moke
mole66251832mole
mome85239352mome
monte75829772monte
mope86838042mope
more67154522more
moste75925082moste
mot57279422mot_
motel76623242motel
motes75944002motes
motet75641192motet
motey105922952motey
moth96731332moth
mots66853162mots
mott66648442mott
motte75526972motte
moue65835572moue
move96630722move
mule65236972mule
mure65941332mure
muse67136032muse
mut58357182mut_
mutate83017482mutate
muted85023382muted
muter74525542muter
mutes75033782mutes
muts64839982muts
mutt65739402mutt
myth126715432myth
nabe66029492nabe
nae35952742na_e
name65637412name
nape65230802nape
nates55238332nates
nave75732312nave
nite45943582nite
note46239962note
oat39888262oat_
oaten55222402oaten
oater55433732oater
oath76132152oath
oats46554212oats
orate55133302orate
ovate84214392ovate
pace86345772pace
page76036102page
pale66055012pale
pane64950292pane
pare66760842pare
pase65346862pase
paste74932952paste
pat58089462pat_
pated85237842pated
paten74827342paten
pater74740722pater
pates76047892pates
path99134912path
pats66460852pats
paty95234562paty
pave96133892pave
plate74635112plate
prate75135982prate
qat125253332qat_
qats135331342qats
quate144521412quate
race66746262race
rage55742352rage
rake84841572rake
rale45050562rale
ramate83921682ramate
rape65041632rape
rare45348432rare
rase46149982rase
rat37892742rat_
rated65441382rated
ratel54224882ratel
rater54943282rater
rates55352012rates
rath76037662rath
rathe85821922rathe
rato45436972rato
rats46260372rats
rave75542092rave
raze135235432raze
remate84428682remate
rete44944132rete
rite45849452rite
rote46249022rote
sabe66140572sabe
sade55544472sade
sae38365182sa_e
safe75930952safe
sage55044592sage
sake85244962sake
sale44959702sale
same65245642same
sane45954342sane
sat36288482sat_
sated66238532sated
satem76021462satem
sates54949322sates
sati45539332sati
saute55028082saute
save75741362save
site47052412site
skate94721552skate
slate55438282slate
smaze165012932smaze
smite75224872smite
smote75820282smote
spate74731582spate
state56237332state
tace65342512tace
tae38267052ta_e
take84739262take
tale46154162tale
tame66343662tame
tape64538142tape
tare45957622tare
taste55127232taste
tat37690292tat_
tater54138612tater
tates55444982tates
tats46858132tats
tote46643672tote
urate55432162urate
ute35335882_ute
vale74937342vale
vane75534692vane
vase75629652vase
vat67863452vat_
vats76841742vats
vatu76524332vatu
vote74728622vote
wade85237062wade
wae67556952wa_e
wage84834082wage
wake114935702wake
wale74546432wale
wame95035482wame
wane76344722wane
ware76254722ware
waste86125052waste
wat67378922wat_
water84733312water
wats77555882wats
watt75545412watt
wave105234732wave
wite75443272wite
wyte106018642wyte
yare75636942yare

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.0632836365.1
2DLD Change Limit298725150.92332364.0
3Display Results5155150.1234187.0
 (SQL Overall)1786915151.109161128.0
 
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.