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

176 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
matte7562684(None) 
latte55426301latte
mate65154221ma_te
matt65752661matt_
matted94521411matted
matter84325341matter
mattes85624531mattes
matts76829181matts
motte75526971motte
ante46538902_ante
ate37059242_a_te
att35454652_att_
baste74829982baste
bate66552422ba_te
bathe105822882bathe
batt65053872batt_
batted95623652batted
batten85217122batten
batter84928872batter
battle85217862battle
batts76727562batts
battu75216612battu
battue84311002battue
batty105422242batty
butte74924292butte
carte75940422carte
caste75932362caste
cate66254602ca_te
catted95422472catted
cattie85221022cattie
cattle85118902cattle
catty104520412catty
date56443322da_te
datto65416422datto
fate75444282fa_te
fatted105419842fatted
fatten94314902fatten
fatter94523212fatter
fatty115117412fatty
fytte1138582fytte
gate55746572ga_te
haste85927862haste
hate78450172ha_te
hatted104921512hatted
hatter94724872hatter
haute89521612haute
late47560482la_te
lathe85626712lathe
latke94817092latke
latten65018202latten
latter65027892latter
lattes65324202lattes
lotte54923852lotte
mabe85733362ma_be
mace87345792ma_ce
mache125925302mache
macle96127002macle
made75440242ma_de
madre85720172madre
mae57659112ma__e
mage75739132ma_ge
mahoe10315572mahoe
maile75232222maile
maize164618562maize
make105537892ma_ke
malate84624552malate
male66052302ma_le
malt66254812malt_
malted94819862malted
malts76331752malts
malty106721702malty
mamie95826002mamie
mane65052032ma_ne
mange84930192mange
manse75528232manse
manta75629912manta
mantel84317972mantel
mantes84430782mantes
mantle84420922mantle
maple95521142maple
mare64759332ma_re
marge85328332marge
marse76231152marse
mart66865982mart_
marted94425212marted
marten84518262marten
marts77442232marts
masse75125292masse
mast65959962mast_
masted94025802masted
master84831342master
masts77035762masts
mat58083942ma_t_
match125621102match
mated85537782mated
mater74438862mater
mates75251362mates
matey107022662matey
math95437452ma_th
maths105624022maths
matier84321522matier
matin75132852matin
matres84522232matres
mats65460292ma_ts
matters94421752matters
mattery123810712mattery
mattin84416632mattin
mature8313462mature
matza16311812matza
matzo16312892matzo
maut65448452maut_
mauts75927192mauts
mauve104013272mauve
mavie104722562mavie
maybe12311132maybe
maze155434982ma_ze
metate82720532metate
mete64438132m_ete
metre74821302metre
mettle83815722mettle
mite66249412m_ite
mitre75522422mitre
mitt66145492mitt_
mitten83914092mitten
mitts75523752mitts
monte75829772monte
moste75925082moste
mote67048082m_ote
motet75641192motet
mott66648442mott_
mottes85523692mottes
mottle84116052mottle
motto76119512motto
motts76527002motts
mutate83017482mutate
mute65136872m_ute
mutt65739402mutt_
mutter84418882mutter
mutts75120252mutts
natter64420742natter
natty85719142natty
paste74932952paste
pate65350462pa_te
patted94724682patted
pattee84323382pattee
patten84418192patten
patter84628262patter
pattie84020962pattie
patty104723612patty
rate45458762ra_te
rathe85821922rathe
ratite65022422ratite
ratted74923342ratted
ratten64217382ratten
ratter64326312ratter
rattle64717612rattle
ratty84819592ratty
rotte54625932rotte
sate45556102sa_te
saute55028082saute
smatter93613332smatter
state56237332state
taste55127232taste
tate44748602ta_te
tatted74920532tatted
tatter64024572tatter
tattie64817512tattie
tattle64115652tattle
tatty84720182tatty
vatted104214732vatted
waste86125052waste
watt75545412watt_
watter93221982watter
wattle94314212wattle
watts86923092watts
yatter94116212yatter

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.0931921408.6
2DLD Change Limit538001761.39038705.0
3Display Results1761760.0463826.1
 (SQL Overall)1786911761.529116867.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.