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

119 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
ramets8351739(None) 
armets84918351armets
ramees84620891ramees
ramet75743141ramet_
ramjets1635161ramjets
abets75621672_abets
amens75624842_amens
aments85219802_aments
arames84622572arame_s
armers85520272armers
armet76739452armet_
armlets94610062armlets
cadets96316512cadets
camels105217082camels
cameos105818002cameos
cames97047312came_s
camlets114314622camlets
carets85330772carets
comets105823582comets
dames85435852dame_s
emmets10349152emmets
facets116316652facets
fames105735922fame_s
framers125113822framers
frames115119862frame_s
fumets114311812fumets
gamers94420832gamers
games86238552game_s
gamest94919932gamest
gamete9313592gamete
gametes10312252gametes
gamuts958782gamuts
haets86525122ha_ets
hames106138702hame_s
hamlets123211402hamlets
kames115024692kame_s
lameds94812032lameds
laments94314852laments
lames75445542lame_s
lamest84722762lamest
mameys13449522mameys
mammets103911112mammets
maumets11369692maumets
namers84517332namers
names74833362name_s
palets85122312palets
rabats83116222rabats
rabbets11279422rabbets
racers84725432racers
races74943242race_s
rachets124516832rachets
rackets134916872rackets
rafts87820632ra_fts
ragees74618662ragees
rages64539442rage_s
raiments1039902raiments
rajes125022782raje_s
rakees104516972rakees
rakers104123572rakers
rakes94440352rake_s
rales54947492rale_s
ramate83921682ramate
ramee74633852rame_e
ramen75625192rame_n
ramenta9311182ramenta
ramies84630462ramies
ramjet15311542ramjet_
rammers113715042rammers
ramous8417112ramous
ramps96224632ram_ps
rams65950772ram__s
ramus76418282ram_us
ranees64623962ranees
rants55935342ra_nts
rapers84327182rapers
rapes75740722rape_s
rares55247442rare_s
rarest65725482rarest
rasers64526782rasers
rases55447212rase_s
ratels64518212ratels
raters63936582raters
rates55352012rate_s
rats46260372ra__ts
ravels94717072ravels
ravens93916882ravens
ravers94628182ravers
raves85441972rave_s
rawest93615062rawest
raxes124729392raxe_s
razees154314762razees
razers154919612razers
razes145032702raze_s
reamers94221082reamers
relets64025672relets
remeets93712412remeets
remelts93511492remelts
remet74843722remet_
remits85622942remits
resets65427612resets
rets45352562r__ets
revets94022172revets
rewets94617212rewets
rimers84522552rimers
rimes75634542rime_s
rivets94417112rivets
roamers93713462roamers
romeos84013172romeos
rosets65819952rosets
rumens83611812rumens
sameks12409322sameks
samlets93813552samlets
tamers84224032tamers
tames75242012tame_s
tamest85721292tamest
tramels93812492tramels
valets93715622valets
wames106432802wame_s
yamens114010822yamens

Search took 4 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 Filter178691825510.343520965.0
2DLD Change Limit825511192.70330540.5
3Display Results1191190.0462587.0
 (SQL Overall)1786911193.09257791.4
 
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.