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

161 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
remet7484372(None) 
ramet75743141ramet
relet54749821relet
remeet86325471remeet
remelt85123121remelt
remex146315791remex
remit75737221remit
reset55051861reset
revet84938841revet
rewet85135151rewet
armet76739462armet
beet66457542be_et
beget85632562beget
beret74946362beret
beset76739132beset
brevet115717342brevet
cement103321672cement
cermet10321152cermet
comet95946072comet
creme94319322creme_
cremes104517992cremes
deet57356582de_et
deme76536282deme_
dement93825152dement
demes86032692demes
demit84832302demit
eme55837182_eme_
emes65434662_emes
emeu66723432_emeu
emit65438422_emit
emmet94221382emmet
feet75352212fe_et
feme96130542feme_
femes105626222femes
fumet105630222fumet
gemot84024232gemot
genet66038682genet
greet65835322gre_et
helmet113718932helmet
heme95034412heme_
hemes105031082hemes
keet85347352ke_et
kempt134318462kempt
leet45957902le_et
meet65350552me_et
meme85330552meme_
memes94927702memes
met56072432__met
pelmet103419242pelmet
premed114617762premed
premeet11615152premeet
premen105017802premen
preset84430982preset
ramee74633852ramee
ramen75625192ramen
ramets83517392ramets
ramjet15311542ramjet
react74634332react
reamed94326122reamed
reamer84325212reamer
rebec94416542rebec
rebel73421292rebel
rebut75927382rebut
recent83630852recent
recept103319082recept
recit75235102recit
recut74729242recut
rede55037682rede_
reded74829122reded
redes65139132redes
ree37974072re_e_
reed55549622re_ed
reef74938212re_ef
reek85232522re_ek
reel45240532re_el
reemit8717222reemit
rees45364192re_es
reest54938092reest
refect114319332refect
refed93921922refed
refel84920812refel
refelt94521422refelt
refer84822142refer
refit84230062refit
reflet94024232reflet
reft75141272re_ft
regent74127672regent
reges65628792reges
reglet73724232reglet
regret73723532regret
reheat94423942reheat
rehem103815352rehem
reject154116282reject
rekey124014732rekey
relent64431852relent
relets64025672relets
relit55340682relit
rem56150042rem__
reman75730152reman
remap95418102remap
remate84428682remate
remedy1237872remedy
remeets93712412remeets
remelts93511492remelts
remend95216552remend
remint85329982remint
remits85622952remits
remix145916552remix
remixt155014852remixt
remote84222602remote
rems66237722rem_s
renest64529712renest
renew83917512renew
rennet64624852rennet
rent46661242re_nt
rente54733782rente
repeat85127212repeat
repeg84015052repeg
repel74921402repel
repent84728872repent
repot75132622repot
rerent63832452rerent
resat55139682resat
reseat64131492reseat
resect84424702resect
resee54336332resee
resent63833622resent
resets65427612resets
resew84519502resew
resit54241042resit
resmelt9411772resmelt
rest46459842re_st
ret35982832r__et
rete44944132rete_
retem74221952retem
retest64028452retest
revel84423162revel
revert93529112revert
revest94623602revest
revets94022182revets
rewed95425452rewed
rewets94617212rewets
rexes124526952rexes
rheme106214052rheme_
rhemes115913182rhemes
rime65138892rime_
rimed84826372rimed
rimer75429242rimer
rimes75634542rimes
rivet85636362rivet
romeo73719702romeo
roset55945242roset
rumen74419502rumen
seme65836652seme_
semen75724102semen
semes75731582semes
tempt95124842tempt
tenet55542212tenet
trevet94818912trevet
unmet74426392unmet
weet75254152we_et

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 Filter178691538000.610292936.1
2DLD Change Limit538001612.40622360.8
3Display Results1611610.0463500.0
 (SQL Overall)1786911613.06258357.6
 
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.