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

112 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
berate8472902(None) 
aerate64830551aerate
berake124216081berake
berated104422131berated
berates94126851berates
borate85026151borate
cerate84829461cerate
derate74531231derate
acerate92818912acerate
aerated85322372aerated
aerates74627482aerates
aurate64426472aurate
barbate11314542barbate
barite84224812barite
baryte115312882baryte
bate66552422b__ate
beat66168302be_at_
beaten84617062be_aten
beater84729392be_ater
beats76042242be_ats
became123213162became
bedmate1239432bedmate
bedrape1277692bedrape
begat86629722begat_
begaze1838332begaze
behave14209012behave
belated103520012belated
bemata10411692bemata
bename103316072bename
beraked144312432beraked
berakes134815772berakes
bereave1258352bereave
beret74946362beret_
berets85822522berets
berime105317332berime
berme96022942ber_me
berth104917882ber_th
betake124512702betake
beware11313712beware
binate8419772binate
blate75933782b_late
borage93917012borage
borane84620212borane
borated104116362borated
borates94823012borates
brace95629272b_race
brae65639112b_ra_e
brake116025342b_rake
brat66055542b_rat_
brats75336012b_rats
brave104925502b_rave
braze165423452b_raze
breath113916262breath
breathe123711842breathe
brute75321782b_rute
bursate94111202bursate
carate84734002carate
cerated103922472cerated
cerates95428232cerates
cerite84724872cerite
crate76537402_crate
create85126372create
curate85226242curate
debate94419192debate
delate73827752delate
derat65044082derat_
derated93623502derated
derates84028882derates
derats74625062derats
elate55335882_elate
enate54428142_enate
erase54925492_erase
ergate7315142_ergate
fermate122813002fermate
ferrate103014032ferrate
gelate73421252gelate
grate64932882_grate
gyrate104912522gyrate
irate55627982_irate
iterate71119102iterate
karate105320922karate
legate72917452legate
liberate101113382liberate
lyrate94112102lyrate
metate82720532metate
negate72915572negate
nervate1039522nervate
operate9615732operate
orate55133302_orate
overate10620962overate
pedate93117762pedate
pirate82322882pirate
prate75135982_prate
rate45458762__rate
rebate84424102rebate
recrate92621642recrate
redate74124682redate
regrate82618652regrate
relate64033632relate
remate84428682remate
sedate73019802sedate
senate63725142senate
serape84818412serape
seriate73722472seriate
serrate73017532serrate
terete6319332terete
ternate7415482ternate
uprate83916542uprate
urate55432162_urate
velate93720142velate
verite94323442verite
verste94515632verste

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 Filter178691825510.1231452772.4
2DLD Change Limit825511122.53332590.2
3Display Results1121120.0303733.3
 (SQL Overall)1786911122.68666526.8
 
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.