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

425 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
revolt931622(None) 
revolts1038891revolts
abvolt11169832abvolt
devout10712992devout
premolt11312072premolt
reboot84119332reboot
recoat84024272recoat
redout71820252redout
refelt94521422refelt
refold103812112refold
regilt71217492regilt
remelt85123122remelt
remold93412972remold
replot83818592replot
repoll8410792repoll
report85326012report
repot75132622repo_t
reroll6412682reroll
resold73915362resold
resole64624182resole
resort65728612resort
result6318222result
retold73013752retold
retort66831142retort
revel84423162revel_
revels94220572revels
revert93529112revert
revest94623602revest
revet84938842rev_et
revile94921612revile
revoke135216242revoke
revolted12319862revolted
revolter11279362revolter
revolute1176792revolute
revolve13328372revolve
revote94917452revote
volt76439532__volt
abvolts12104373abvolts
areola6813673are_ola
areole61017283are_ole
begot84625953bego_t
behold1247343behold
belt65754033be__lt
besot76429713beso_t
bevel104517043bevel_
bevels113913983bevels
bevomit1445353bevomit
bevor101510813bevo_r
bevors111610343bevors
bolt66254173__bolt
brevet115717333brev_et
cavort11316173cavort
celt65646713ce__lt
colt67158243__colt
creole8913723cre_ole
cresol8310203cresol_
cresols939643cresols
dealt65234283de_alt
decoct11313783decoct
dehort104618103dehort
delt57855273de__lt
demivolt1454573demivolt
deport94922393deport
depot85727923depo_t
desalt7518313desalt
devel94217123devel_
devels104313903devels
devest104418703devest
devil94714733devil_
devils104412813devils
devoid1189353devoid
devoir1076033devoir
devolve14316063devolve
devon95113683devo_n
devons104512253devons
devote104513783devote
devour1076703devour
divot95723073divo_t
dolt56649423__dolt
enol45823823_enol_
enols54718403_enols
ergot65422893ergo_t
ervil8310303ervil_
ervils948773ervils
event85924443_event
evert84929513_evert
evict104417143_evict
evil75318073_evil_
evils84114263_evils
evoke12478853_evoke
evolute1045683_evolute
evolve12306503_evolve
exalt123018533_exalt
exult122814123_exult
eyebolt1246363eyebolt
felt75146933fe__lt
frivol1235113frivol_
frivols1334743frivols
gavot9321113gavo_t
gelt56448013ge__lt
gemot84024233gemo_t
helot85332683helo_t
holt77852583__holt
jolt116639123__jolt
kelt85343193ke__lt
ketol95414003ketol_
ketols104210763ketols
kevel124213093kevel_
kevels134410713kevels
kevil12399863kevil_
kevils13358333kevils
levant9314493levant
level84116553level_
levels94113283levels
levo76820063levo__
megavolt1444563megavolt
melt65752893me__lt
merlot83217603merlot
metol75917813metol_
metols84115773metols
molt66356163__molt
nerol51017813nerol_
neroli61111153neroli
nerols6914883nerols
nevoid1098793nevoid
ovoli8358283_ovoli
ovolo8339173_ovolo
pelt67651083pe__lt
penult8314653penult
peyotl1146233peyotl
pivot106523873pivo_t
premold1247863premold
presold1059603presold
presort95219533presort
pretold1049083pretold
prevent124016553prevent
provost1238573provost
ragout7317183ragout
ravel84621513ravel_
ravels94717073ravels
ravioli1055613ravioli
react74634333re_act
readopt10410843readopt
readout8615493readout
real45750293re_al_
reallot7312133reallot
really93315613really
realm75621623re_alm
reals55038653re_als
realty92713693re_alty
reavow1235723reavo_w
reavows1335273reavows
rebait8320403rebait
rebel73421293rebel_
rebels84518133rebels
rebill84713253rebill
reboant9315093reboant
rebody1238153rebody
reboil83814683reboil
reboils94111723reboils
rebook125213203rebook
reboots93512093reboots
rebop9313283rebo_p
rebops10311433rebops
rebore86625643rebore
reborn810016953reborn
rebozo1737323rebozo
rebuilt939973rebuilt
rebut75927383re_but
recall83815723recall
recant83228683recant
recast83422773recast
recent83630853recent
recept103319073recept
recit75235103re_cit
recoal84117973recoal
recoals94214623recoals
recoats92616643recoats
recock145112723recock
recode93618713recode
recoil84016723recoil
recoils93814873recoils
recoin84320293recoin
recolor978693recolor
recomb1238873recomb
recon75624243reco_n
recons84922993recons
recook125513923recook
recopy1339043recopy
record96117423record
recork126315483recork
recount9315173recount
recoup10810373recoup
recut74729243re_cut
redact9419043redact
redcoat10410883redcoat
reddle83815913reddle
redipt94116743redipt
redly94217193re_dly
redo56029363redo__
redock134311543redock
redoes74623753redoes
redolent9411883redolent
redon65424883redo_n
redone74820053redone
redons75222183redons
redos65126763redo_s
redoubt10167843redoubt
redouts81411653redouts
redowa1038453redowa
redox134714233redo_x
redpoll1045043redpoll
redroot8312903redroot
reedit7617223reedit
reel45240533re_el_
reels55333263re_els
reemit8717223reemit
reest54938093re_est
reevoke14386363reevoke
refall94314393refall
refect114319333refect
refel84920813refel_
refell94214443refell
refels94618053refels
refile95122373refile
refill94514053refill
refilm114311403refilm
refit84230063re_fit
reflet94024233reflet
refloat10310833refloat
reflow12379653reflow
refly113914563re_fly
refolds11298953refolds
reform11312703reform
refront10313263refront
reft75141273re__ft
regal65023793regal_
regale74821453regale
regent74127673regent
regild8149773regild
reglet73724233reglet
reglow10339403reglow
regolith1247543regolith
regret73723533regret
reguli738143reguli
reheat94423943reheat
reject154116283reject
rejoin134012243rejoin
reknit10312533reknit
reknot10311733reknot
relent64431853relent
relet54749823re_let
relict83623903relict
relist64628413relist
relit55340683re_lit
reload7413893reload
reloan6415693reloan
relock124713523relock
relook104813743relook
reluct83916113reluct
rely75428953re__ly
remeet86325473remeet
remelts93511493remelts
remet74843723re_met
remint85329973remint
remit75737223re_mit
remixt155014853remixt
remolds10299703remolds
remora8414583remora
remote84222603remote
remount9512283remount
remove116115573remove
renal55929503renal_
renest64529713renest
rennet64624853rennet
renown9369983renown
rent46661243re__nt
renvoi945863renvo_i
renvois1036503renvois
reoil55321183re_oil
reoils64516873reoils
repast83520633repast
repeat85127213repeat
repel74921403repel_
repels84318763repels
repent84728873repent
replots93412633replots
replow114210343replow
reply104015853re_ply
repo66027543repo__
repolls939053repolls
reports94916213reports
repos74725793repo_s
repose84121413repose
reposit9315863reposit
repots85621003repots
repour8310993repour
rerent63832453rerent
rerolls739943rerolls
reroof9315003reroof
rerose63320843rerose
reroute7313963reroute
resale64025543resale
resat55139683re_sat
reseat64131493reseat
resect84424703resect
resell64215203resell
resent63833623resent
reset55051863re_set
reshoot102513893reshoot
reshot93519633reshot
resift94017723resift
resile64627673resile
resist64524533resist
resit54241043re_sit
resmelt9411773resmelt
resoak10311093resoak
resod64720053reso_d
resods74116303resods
resojet14312823resojet
resoled84119283resoled
resoles73823653resoles
resolute868513resolute
resolve103910983resolve
resorb84914343resorb
resorts74817193resorts
resow88217243reso_w
resown94112923resown
resows93915353resows
respelt9312143respelt
resplit9310373resplit
respot83117633respot
rest46459843re__st
results739833results
ret35982833re___t
retell63813643retell
retest64028453retest
retile65929673retile
retint65633443retint
retook104313443retook
retool63914483retool
retools73411023retools
retore67630763retore
retorn610923423retorn
retorts76016513retorts
rev65336623rev___
revalue1038153revalue
revamp1336013revamp
reveal94115053reveal
reveals103812723reveals
reveled113917753reveled
reveler104116343reveler
revelry1335693revelry
reverb113912573reverb
revere94621253revere
revers94529633revers
reverts104715043reverts
revery124014213revery
revests104413733revests
revets94022173revets
review1238693review
reviled114417923reviled
reviler104314973reviler
reviles104421353reviles
reviolate1248123reviolate
revise94019743revise
revisit10311373revisit
revive124914823revive
revoice12319183revoice
revoked154410523revoked
revoker14419193revoker
revokes144212503revokes
revolters12297483revolters
revolting1339633revolting
revolved15328103revolved
revolver14287713revolver
revolves14278623revolves
revoted114314153revoted
revotes104716393revotes
revs75027053rev__s
revue81114453rev_ue
revues9813903revues
revuist1038473revuist
revved13469723revved
reweld103711113reweld
rewet85135153re_wet
rewoke1339521213rewoke
rewon86920573rewo_n
reword106321403reword
rewore938030153rewore
rework136619783rework
reworn98122193reworn
rewove126420073rewove
rezone153814783rezone
riot45947213r_io_t
ripost83615003ripost
rival85216503rival_
rivals94213183rivals
rivet85636363riv_et
rivulet1069723rivulet
robot7325973robo_t
role45851823r__ole
rolf75134873r__olf
roll46331653r__oll
roost55730933r_oost
root45655923r__oot
rot37282953r__o_t
rotl45029683r__otl
rout46153283r__out
rubout8313553rubout
rugola736293rugola
runout6414873runout
ryot75528563r_yo_t
setout64719463setout
smolt74824163_smolt
tremolo946513tremolo
trevet94818913trev_et
unbolt83013893unbolt
vole75236983__vole
volta85215623__volta
volte85321303__volte
volti84915963__volti
volts85421293__volts
welt75547863we__lt
zealot15313473zealot

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 Filter1786911127160.1701051123.5
2DLD Change Limit1127164256.06318590.8
3Display Results4254250.1432972.0
 (SQL Overall)1786914256.37628025.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.