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

136 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
menta7442442(None) 
manta75629911manta
mensa75318671mensa
mental84521601mental
meta65932411me_ta
omenta83411721omenta
yenta83917041yenta
ament76036542ament_
amentia9310152amentia
aments85219802aments
anta46839582_anta
bent67759912bent_
bento75922952bento
bents76033692bents
beta66234132be_ta
betta74916842betta
cementa112810542cementa
cent67451012cent_
centai84814782centai
cental84420962cental
centas85020702centas
cento76625172cento
centra84113882centra
cents74730332cents
centu76119412centu
cesta75419482cesta
delta66117772delta
dent57158412dent_
dental74319172dental
dents65031802dents
entia5318202_entia
eta35834192_e_ta
etna46415262_etna
feta76528902fe_ta
genoa64315822genoa
gent56954392gent_
gents65729612gents
genua64614152genua
geta56627442ge_ta
henna84414042henna
hent76656382hent_
hents87330742hents
junta123713672junta
kent86846972kent_
kente95821072kente
lent46360532lent_
lento57223392lento
lepta75714392lepta
lomenta92710132lomenta
magenta1038622magenta
mana65341962man_a
manat76039992manat
manga85026212manga
mania75634152mania
manna75522542manna
mantas85725362mantas
mantra84116092mantra
mantua84412022mantua
meant76537212meant_
meat66359602meat_
meatal84114732meatal
meats75034052meats
meaty107021312meaty
mecca1139932mecca
media84721712media
meet65350552meet_
meets74224612meets
mega77620872me_ga
melt65752892melt_
melts74930102melts
melty104918362melty
men59252852men__
menad85918982menad
mend75334032men_d
mends84927692mends
menial84223032menial
meno66031362men_o
mensae84114052mensae
mensal84615662mensal
mensas85115862mensas
mense75025632mense
mensh105413562mensh
mentee84121292mentee
mentor8414362mentor
mentum104511712mentum
menu65130232men_u
menus75822842menus
mesa67025482me_sa
met56072432me_t_
metal75427382me_tal
mete64438132me_te
meth95827842me_th
mina65136932min_a
mint66758072mint_
mints76834042mints
minty106323902minty
momenta11299852momenta
monte75829772monte
month104818422month
myna95815302myn_a
omental93210422omental
penna74520202penna
pent66559072pent_
pentad9313762pentad
pinta75727052pinta
ramenta9311182ramenta
reata54225392reata
recta74220262recta
rent46661242rent_
rental63922032rental
rente54733782rente
rents55935182rents
senna54617982senna
sensa54117472sensa
sent46963012sent_
sente56432882sente
senti56226702senti
septa75518082septa
seta45637312se_ta
tecta74215522tecta
tenia55324482tenia
tent46159862tent_
tenth85421832tenth
tents56434212tents
tenty86121602tenty
testa54822042testa
tomenta9319832tomenta
vena76126292ven_a
vent76049052vent_
vents86125932vents
vesta86618302vesta
went76051872went_
xenia124814772xenia
yentas94614212yentas
yente86220042yente
zeta135121642ze_ta

Search took 3 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.296603685.8
2DLD Change Limit538001361.75030742.9
3Display Results1361360.0304533.3
 (SQL Overall)1786911362.07686074.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.