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

174 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
revet8493884(None) 
brevet115717331brevet
relet54749821relet
remet74843721remet
reset55051861reset
revel84423161revel
revert93529111revert
revest94623601revest
revets94022171revets
rewet85135151rewet
rivet85636361rivet
trevet94818911trevet
beet66457542be_et
beget85632562beget
beret74946362beret
beset76739132beset
bevel104517042bevel
breve105317052breve_
breves115516422breves
brevets12519392brevets
civet105828732civet
covet105638942covet
deet57356582de_et
devel94217122devel
devest104418702devest
duvet9321872duvet
eve66331162_eve_
even75222272_even
event85924442_event
ever77027692_ever
evert84929512_evert
eves76230462_eves
feet75352212fe_et
fever115617952fever
genet66038682genet
greet65835322gre_et
grivet103517822grivet
keet85347342ke_et
kevel124213102kevel
leet45957902le_et
levee84023812levee
level84116552level
lever85125162lever
meet65350552me_et
neve76224832neve_
never86218642never
neves87021872neves
preset84430982preset
prevent124016552prevent
privet113821342privet
ramet75743142ramet
rave75542092rave_
raved94931432raved
ravel84621512ravel
raven84723442raven
raver85631492raver
raves85441972raves
react74634332react
reave84528022reave_
reaved104523922reaved
reaver94524732reaver
reaves94127572reaves
rebec94416542rebec
rebel73421292rebel
rebut75927382rebut
recent83630852recent
recept103319072recept
recit75235102recit
recut74729242recut
rede55037672rede_
reded74829122reded
redes65139132redes
ree37974072re_e_
reed55549622re_ed
reef74938212re_ef
reek85232522re_ek
reel45240532re_el
rees45364192re_es
reest54938092reest
reeve84121322reeve
reeved104118712reeved
reeves94721492reeves
refect114319332refect
refed93921922refed
refel84920812refel
refelt94521422refelt
refer84822142refer
refit84230062refit
reflet94024232reflet
reft75141272re_ft
regent74127672regent
reges65628792reges
reglet73724232reglet
regret73723532regret
reheat94423942reheat
rehem103815352rehem
reive85522942reive_
reived104518132reived
reiver95318292reiver
reives95723042reives
reject154116282reject
rekey124014732rekey
relent64431852relent
relets64025672relets
relit55340682relit
remeet86325472remeet
remelt85123122remelt
remex146315792remex
remit75737222remit
renest64529712renest
renew83917512renew
rennet64624852rennet
rent46661242re_nt
rente54733782rente
repeat85127212repeat
repeg84015052repeg
repel74921402repel
repent84728872repent
repot75132622repot
rerent63832452rerent
resat55139682resat
reseat64131492reseat
resect84424702resect
resee54336332resee
resent63833622resent
resets65427612resets
resew84519502resew
resit54241042resit
rest46459842re_st
ret35982832r__et
rete44944132rete_
retem74221952retem
retest64028452retest
rev65336622rev__
reveal94115052reveal
revels94220572revels
reverb113912572reverb
revere94621252revere
revers94529632revers
reverts104715042reverts
revery124014212revery
revests104413732revests
review1238692review
revolt9316222revolt
revote94917452revote
revs75027052rev_s
revue81114452revue
revues9813902revues
revved13469722revved
rewed95425452rewed
rewets94617212rewets
rexes124526952rexes
riever94811652riever
rive75537722rive_
rived94825612rived
riven85121622riven
river85731692river
rives85336002rives
rivets94417112rivets
roset55945242roset
rove75136982rove_
roved95323552roved
roven85521972roven
rover85527372rover
roves84834482roves
seven84118312seven
sever85426052sever
tenet55542212tenet
trevets10499972trevets
trivet93721882trivet
velvet123613752velvet
vervet124619062vervet
vet65958522__vet
weet75254152we_et

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.313570897.8
2DLD Change Limit538001741.89028465.6
3Display Results1741740.0503480.0
 (SQL Overall)1786911742.25379312.5
 
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.