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 “ramenta” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

186 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
ramenta931118(None) 
ament76036542_ament_
amentia9310152_amentia
aments85219802_aments
cementa112810542cementa
lament85024942lament_
laments94314852laments
lomenta92710132lomenta
magenta1038622magenta
menta74424422__menta
momenta11299852momenta
omenta83411722_omenta
paramenta1368862paramenta
raiment9315412raiment_
raiments1039902raiments
ramen75625192ramen__
ramentum1244862ramentum
ramet75743142rame_t_
ramets83517392rame_ts
ramona8412412ramon_a
sarmenta1047722sarmenta
tomenta9319832tomenta
aceta74017353_ace_ta
agenda837253_agenda
agent65829643_agent_
agents74816293_agents
amanita9310453_amanita
ameba9312383_ame_ba
amen66733153_amen__
amend85717753_amen_d
amends94713283_amends
amenity1238333_amenity
amens75624843_amen_s
amentias1039413_amentias
amnia75918643_am_nia
amreeta945163_amreeta
amrita8411133_amrita
anent54931843_anent_
anta46839583_a__nta
ardent73022613ardent_
arena55323813_aren_a
argent74023663argent_
argental947933argental
argents84014853argents
argumenta1244583argumenta
arietta788903arietta
armament1249633armament_
armaments1347473armaments
armet76739453arme_t_
armets84918353arme_ts
arpent84822093arpent_
arpents93613083arpents
cadent94120363cadent_
cadenza1943773cadenza
camelia11510433camelia
camera10313693came_ra
catena8312483caten_a
cement103321673cement_
cements112714223cements
dement93825153dement_
dementia1157833dementia
dements103016623dements
dracena1034923dracen_a
faena85014203fa_en_a
fazenda2043253fazenda
foment113718303foment_
foments122912053foments
fraena938063fra_en_a
fragment1448373fragment_
fragmental1653643fragmental
fragments1546213fragments
fromenty1645243fromenty
frumenty1644573frumenty
galena74911093galen_a
gamest94919933gamest_
gametal1037603game_tal
gamete9313593game_te
garment10315233garment_
garments1139963garments
hymenia1546393hymenia
lambent113711303lambent_
lamella988613lamella
lamented1138193lamented
lamenter1038863lamenter
lamest84722763lamest_
lamina84920443lamin_a
latent64124303latent_
latents75214313latents
loment84021473loment_
loments93413473loments
magentas1137923magentas
manta75629913__manta
maranta9311693maranta
memento11378133memento
mensa75318673__mensa
mental84521603__mental
meta65932413__me_ta
moment103319683moment_
momento11348903momento
moments113113123moments
nametag1044443name_tag
omental93210413_omental
ornament1049133ornament_
ornamental1264643ornamental
ornaments1146633ornaments
parament12415393parament_
paraments13511553paraments
parent83230423parent_
parental10310943parental
parents93418123parents
patent84524923patent_
patents94815203patents
payment14310703payment_
payments1536943payments
pimento1157223pimento
placenta1275723placenta
polenta9310093polenta
ragmen93712183ragmen__
raita54623073ra__ita
ramada9310183ram_ada
ramate83921683ram_ate
rambla103510933ram_bla
rambutan1243403rambutan
ramee74633853rame__e
ramees84620893rame_es
ramekin13126493ramekin
ramjet15311543ramjet_
ramjets1635163ramjets
ramonas9311093ramonas
rampant11312173rampant_
rant45864683ra__nt_
rants55935343ra__nts
rarest65725483rarest_
raven84723443raven__
ravened115012283ravened
ravener104110743ravener
ravens93916883raven_s
rawest93615063rawest_
reagent8716603reagent_
reagents959623reagents
reata54225393r__eata
recent83630853recent_
recta74220263r__ecta
regent74127673regent_
regental948943regental
regents83416543regents
relent64431853relent_
relents74018503relents
remeet86325473remeet_
remeets93712413remeets
remelt85123123remelt_
remelts93511493remelts
remend95216553remen_d
remends105013033remends
remet74843723reme_t_
remint85329983remint_
remints95117293remints
rent46661243r__ent_
rental63922023r__ental
rente54733783r__ente
rents55935183r__ents
repent84728873repent_
repents93717623repents
rerent63832453rerent_
rerents73319423rerents
resent63833623resent_
resents74221223resents
rident7520193rident_
rodent7519243rodent_
rodents8611543rodents
rumen74419503rumen__
rumens83611813rumen_s
rumina83412483rumin_a
sarment9318763sarment_
sarments10311963sarments
taenia6313193ta_enia
talent6323323talent_
talents7312013talents
tamest85721293tamest_
tapeta8310693tape_ta
tegmenta1155613tegmenta
varment12313243varment_
varments1339063varments
yamen104115183yamen__
yamens114010823yamen_s
yenta83917043__yenta

Search took 7 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 Filter1786911340270.423422437.4
2DLD Change Limit1340271866.06322105.7
3Display Results1861860.0603100.0
 (SQL Overall)1786911866.54627297.7
 
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.