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

133 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
revengers133641(None) 
revenger1237301revenger_
revenges1238981revenge_s
revenuers1235981revenuers
avengers1235582_avengers
eveners10109502_even_ers
preventers1547392preventers
raveners11309132raven_ers
reenters82915312re_enters
renegers9248792rene_gers
repenters112511552repenters
revealers12318242revealers
revelers113414132reve_lers
revellers12319512revellers
revenge1138572revenge__
revenged1337552revenge_d
revenuer1136892revenuer_
revenues1138662revenue_s
reverers113113152reve_rers
reversers12298482reversers
reverters122710432reverters
avenger1135493_avenger_
avenges1157543_avenge_s
befingers1544103befingers
bevelers13389463beve_lers
bevellers14276143bevellers
cementers1338313cementers
decenters122410373decenters
defenders1436363defenders
degenders1236083degenders
demergers13146403demergers
derangers1136703derangers
deringers1137183deringers
detergers11147183detergers
emenders11319033_emenders
evangels1243733_evangels
evener91010623_even_er_
evenness1135543_evenness
inventers12269533inventers
keeners113610783ke_en_ers
lavenders1334753lavenders
levanters1254993levanters
levelers11259323leve_lers
levellers12286053levellers
liveners11217933liven_ers
messengers1342913messengers
preeners102712813pre_en_ers
presenters1239863presenters
pretenders1345243pretenders
preventer1438593preventer_
provenders1644273provenders
rangers83621043r__angers
ravagers1235583rav_agers
ravelers113310863rave_lers
ravellers12257163ravellers
ravener104110743raven_er_
recanters112310483recanters
receivers1436363receivers
recensors1176133recensors
recenter102715443recenter_
reconfers1437213reconfers
redeemers1244813redeemers
redenies9615713redenie_s
reefers103312593re_e_fers
reekers113613143re_e_kers
reelers73520273re_e_lers
reenter73217793re_enter_
refences13311853refence_s
referrers12125373referrers
refiners114713313refin_ers
refunders1334973refunders
reheaters122010273reheaters
rehinges1248403rehinge_s
reinters82614773re_inters
rejecters18257543rejecters
rejiggers1843013rejiggers
releasers937323releasers
reletters9138783reletters
remembers1544493remembers
remerges111110203remerge_s
reminders12308653reminders
renders83821673r__enders
reneger8299493rene_ger_
reneges82513593rene_ge_s
renewers11238183rene_wers
renters74224823r__enters
repealers11278843repealers
repeaters112811993repeaters
repellers11278883repellers
repenter102813863repenter_
repiners103913433repin_ers
resellers9299933resellers
reservers12138103reservers
resetters9129463resetters
resigners1036863resigners
retempers1345023retempers
retenes76324623reten_e_s
revampers1653443revampers
revealer113110073revealer_
reveler104116343reve_ler_
reveller112912193reveller_
revenants1246173revenants
revengeful1751503revengeful
revenging1438083revenging
revenue1039533revenue__
revenued1237223revenue_d
reverencers1673323reverencers
reverer103815833reve_rer_
reveres103621343reve_re_s
reveries112518513reverie_s
revers94529633rev___ers
reverser113010483reverser_
reverses112513513reverse_s
reverter114812873reverter_
reviewers1543893reviewers
revilers114011693rev_ilers
revisers113511933rev_isers
revivers14389633rev_ivers
revokers15366753rev_okers
revolters12297483revolters
revolvers15286113revolvers
rewinders13246503rewinders
ringers83922953r__ingers
ripeners1036843ripen_ers
riveters11228163rive_ters
scavengers1642083scavengers
teenagers10114493te_enagers
teeners74415453te_en_ers
venders113717003__venders
veneers103710293__veneers
venges104015153__venge_s
venters103717733__venters
vergers114412633__vergers

Search took 8 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 Filter1786911486410.436409841.7
2DLD Change Limit1486411337.28320409.3
3Display Results1331330.0632111.1
 (SQL Overall)1786911337.78222962.1
 
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.