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

235 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
revenge113857(None) 
revenged1337551revenged
revenger1237301revenger
revenges1238981revenges
revenue1039531revenue
avenge1087552_avenge
refence12312222refence
rehinge1148502rehinge
remerge10148922remerge
renege72713762rene_ge
retene69224272reten_e
revengers1336412revengers
revenued1237222revenued
revenuer1136892revenuer
revenues1138662revenues
revere94621252reve_re
reverie103615162reverie
reverse103913742reverse
venge95117982__venge
avenged1245503_avenged
avenger1135493_avenger
avenges1157543_avenges
avenue957953_avenue
beverage1445143beverage
credence1387813credence
defence1339893defence
defense1137503defense
demerge11168023demerge
derange939813derange
detente83313603detente
deterge9118463deterge
diverge12347643diverge
emerge91510463_emerge
evangel1134303_evangel
even75222273_even__
evened101010313_evened
evener91010623_evener
evenly1236993_evenly
evens84817103_even_s
event85924443_even_t
events94814073_events
evince1137763_evince
greenie8310123gre_enie
henge94819823__henge
ketene106613003keten_e
levee84023813leve__e
leverage1285393leverage
lozenge1743243lozenge
melange1038363melange
merengue1143393merengue
novenae1046323novenae
prepense12238933prepense
presence122213503presence
pretence122312113pretence
pretense10199813pretense
prevent124016553preven_t
prevented1539003prevented
preventer1438593preventer
prevents133012293prevents
range64728413r__ange
ravage1039303rav_age
raven84723443raven__
ravened115012283ravened
ravener104110733ravener
ravens93916883raven_s
ravine95522223ravin_e
raving105128853raving_
ravings114614493ravings
reaving113820533reaving_
recane83022873recan_e
recede95515533rece_de
receive1239733receive
recency1438623recency
recent83630853recen_t
recenter102715443recenter
rechange1458183rechange
redenied10511283redenied
redenies9615713redenies
redeny102712733reden_y
redeye103811793rede_ye
reding83825563reding_
redone74820053redon_e
reemerge1154793reemerge
reengage1045213re_engage
reenter73217793re_enter
reeve84121323re_e_ve
reeving113717663reeving_
reevoke14386363reevoke
refenced1438993refenced
refences13311843refences
referee101615753referee
refine95225693refin_e
reforge11259033reforge
refuge105312613re_fuge
regauge945813regauge
regency1337363regency
regent74127673regen_t
regents83416543regents
reginae84713453reginae
regorge9257833regorge
rehang1039823rehang_
rehanged1357833rehanged
rehangs1137563rehangs
rehinged1336853rehinged
rehinges1248403rehinges
rehung1036343rehung_
reimage1037913reimage
reiving113316843reiving_
rejudge1634023rejudge
release7312763release
relend76116453relen_d
relends84013253relends
relent64431853relen_t
relented92614943relented
relents74018503relents
releve95116403rele_ve
reline65434353relin_e
remend95216553remen_d
remended123010393remended
remends105013033remends
remerged12149173remerged
remerges111110203remerges
reneged92010763rene_ged
reneger8299493rene_ger
reneges82513593rene_ges
rente54733783r__ente
repeg84015053repe_g_
repegged1334883repegged
repegs93311943repe_gs
repent84728873repen_t
repented112614983repented
repenter102813863repenter
repents93717623repents
repine85627813repin_e
repledge1243753repledge
replunge1143953replunge
rerent63832453reren_t
rerented92516163rerented
rerents73319423rerents
resee54336333rese__e
reseize1639553reseize
resend75016773resen_d
resends83513713resends
resent63833623resen_t
resented92716963resented
resents74221223resents
reserve101011203reserve
restage83316183restage
resurge839073resurge
retenes76324623retenes
retinae75517333retinae
retine66237333retin_e
retinue75414843retinue
retune69121953retun_e
revalue1038153revalue
revanche1645003revanche
reveal94115053reve_al
revealed123211213revealed
revealer113110073revealer
reveals103812723reveals
reveille1145333reveille
revel84423163reve__l
reveled113917753reveled
reveler104116343reveler
reveling123117083reveling_
revelled123712733revelled
reveller112912183reveller
revelry1335693revelry
revels94220573reve_ls
revenant11410273revenant
revengeful1751493revengeful
revenging1438083revenging
revenual1144783revenual
revenuers1235983revenuers
reverb113912573reve_rb
reverbed14269223reverbed
reverbs12368863reverbs
revered112819333revered
reverence14710153reverence
reverer103815833reverer
reveres103621343reveres
reveries112518513reveries
revering122918073revering_
revers94529633reve_rs
reversed122711613reversed
reverser113010483reverser
reverses112513513reverses
reverso10367693reverso
revert93529113reve_rt
reverted122714713reverted
reverter114812873reverter
reverts104715043reverts
revery124014213reve_ry
revest94623603reve_st
revested122612243revested
revests104413733revests
revet84938843reve__t
revets94022173reve_ts
revetted122210943revetted
revile94921613rev_ile
revise94019743rev_ise
revive124914823rev_ive
revoice12319183revoice
revoke135216243rev_oke
revolve13328373revolve
revote94917453rev_ote
revue81114453rev__ue
revving14379343revving_
reweave1336773reweave
reweigh1464773reweigh
rexine134719443rexin_e
rezone153814783rezon_e
rivage1038843riv_age
riven85121623riven__
riving104521423riving_
roven85521973roven__
roving103618743roving_
rovings11439493rovings
scavenge1442813scavenge
selvedge1342043selvedge
serene63522353seren_e
seven84118313seven__
sevens93813663seven_s
seventh1336773seventh
seventy1338033seventy
severe94016083seve_re
teenage8108053te_enage
tenge65720433__tenge
venae85920983__venae
venene92912523venen_e
venged114011983__venged
venges104015143__venges
venue84918213__venue
verge93419833__verge
weenie92612023we_enie

Search took 10 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.1561145455.1
2DLD Change Limit1340272359.23314516.1
3Display Results2352350.1561506.4
 (SQL Overall)1786912359.54518720.9
 
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.