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

221 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
revelry133569(None) 
revery124014211reve_ry
devilry1433972devilry
every115215452_eve_ry
jewelry2041992jewelry
levelly1335842levelly
ravelly13268352ravelly
revel84423162revel__
reveled113917752reveled
reveler104116342reveler
revelers113414132revelers
revels94220572revel_s
reverb113912572reve_rb
revere94621252reve_re
revers94529632reve_rs
revert93529112reve_rt
rivalry1354032rivalry
beery105220123be_e_ry
bevel104517043bevel__
beveled133811123beveled
beveler124010683beveler
bevelers13389453bevelers
bevels113913983bevel_s
beweary1536223beweary
bravely15428233bravel_y
bravery15428133brave_ry
brevetcy1841723brevetcy
breviary1642613breviary
brewery15376953brewe_ry
cavalry1554963cavalry
celery1139623cele_ry
cleverly1643453cleverly
devel94217123devel__
develed123611933develed
develop13145033develop
devels104313903devel_s
deviltry1542983deviltry
eely77725213_e_el_y
eery76129623_e_e_ry
emery104814333_eme_ry
evenly1236993_evenly
ever77027693_eve_r_
evert84929513_eve_rt
evilly1236593_evilly
fever115617953feve_r_
fevers125414893feve_rs
freely12310953fre_el_y
gravelly15385773gravelly
gravely14469063gravel_y
hellery13329213hellery
kevel124213093kevel__
kevels134410713kevel_s
leery85919133le_e_ry
level84116553level__
leveled114010383leveled
leveler10399903leveler
levelers11259323levelers
levels94113283level_s
lever85125163leve_r_
levers94621323leve_rs
lively123310813livel_y
livery124910903live_ry
lovely12339713lovel_y
loverly1346973loverly
merely111312583merel_y
never86218643neve_r_
novelly1346513novelly
novelty1365173novelty
overly122411363_overly
pedlery13297073pedlery
peery105719443pe_e_ry
preverb14317063preve_rb
rarely93513653rarel_y
ravel84621513ravel__
raveled114113633raveled
raveler104212463raveler
ravelers113310863ravelers
ravelin102211023ravelin
ravels94717073ravel_s
raver85631493rave_r_
ravers94628183rave_rs
readerly1245083readerly
realer63528593realer_
really93315613re_ally
realty92713693re_alty
reaver94524733reave_r_
reavers108320743reave_rs
rebel73421293rebel__
rebels84518133rebel_s
rebury11349213re_bury
recarry1245063recarry
recency1438633recency
recovery16366213recove_ry
rectory123512723rectory
redear73515173redear_
redears82814453redears
redefy13388763rede_fy
redeny102712733rede_ny
redeploy1453173redeploy
redly94217193re_dl_y
redry94314363r__edry
reearn6612143re_earn
reechy14367823re_echy
reedy910020283re_e_dy
reefy114217703re_e_fy
reeky125416263re_e_ky
reel45240533re_el__
reeled74725533re_eled
reeler63822573re_eler
reelers73520273re_elers
reels55333263re_el_s
reentry1038033reentry
refel84920813refel__
refell94214443refel_l
refels94618053refel_s
refelt94521423refel_t
refer84822143refe_r_
refers93921083refe_rs
refly113914563re_fl_y
refry114412463r__efry
regally1159873regally
regear73512743regear_
regears83012463regears
regency1337363regency
rehear93713223rehear_
reheard11309023reheard
rehears103312773rehears
reiver95318293reive_r_
reivers105117083reive_rs
rekey124014733reke__y
relay84424673r__elay
relearn747973relearn
rely75428953r__el_y
remarry1235193remarry
remedy1237863reme_dy
remelt85123123remel_t
remelts93511493remelts
repel74921403repel__
repels84318763repel_s
reperk122511773repe_rk
replay113412923re_play
replevy1533463replevy
reply104015853re_pl_y
resell64215203resel_l
resells73313203resells
retally10413683retally
retear63115483retear_
retears72814923retears
retell63813643retel_l
retells73211523retells
retiary1038333retiary
retry84718083r__etry
revalue1038153revalue
reveal94115053reve_al
revealed123211213revealed
revealer113110073revealer
revealers12318243revealers
reveals103812723reveals
reveille1145333reveille
revelatory16104673revelatory
reveling123117083reveling
revelled123712733revelled
reveller112912183reveller
revellers12319503revellers
revelries1246923revelries
revelrous1243893revelrous
revenge1138573revenge
revenue1039533revenue
reverbs12368863reverbs
revered112819333revered
reverer103815833reverer
reverers113113153reverers
reveres103621343reveres
reverie103615163reverie
reverify1744813reverify
reverse103913743reverse
reverso10367693reverso
reverts104715043reverts
revest94623603reve_st
revests104413733revests
revet84938843reve__t
revets94022173reve_ts
revile94921613revil_e
reviled114417923reviled
reviler104314973reviler
revilers114011693revilers
reviles104421353reviles
revisory14306013revisory
revolt9316223revol_t
revolts1038893revolts
revolve13328373revolve
rewear93011993rewear_
rewears102911033rewears
reweld103711113rewel_d
rewelds11457413rewelds
rezero1578873reze_ro
riever94811653rieve_r_
rievers104311453rieve_rs
rifely123710033rifel_y
riflery13345803riflery
ripely112511153ripel_y
river85731693rive_r_
rivers94626543rive_rs
ropery114313873rope_ry
rosery93813283rose_ry
rover85527373rove_r_
rovers95423523rove_rs
rudely10389973rudel_y
rudery10419033rude_ry
saveloy1334663saveloy
sealery104011053sealery
seely84522633se_el_y
seventy1338033seventy
sever85426053seve_r_
severe94016083seve_re
severs94121123seve_rs
trevally1446343trevally
veery115816253__veery
venery123710663vene_ry
very108025643__ve_ry
wavery154610053wave_ry

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.1531167915.0
2DLD Change Limit1340272216.12621878.4
3Display Results2212210.0932376.3
 (SQL Overall)1786912216.37228043.2
 
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.